Board index Database

Access Form question

Access Form question

Post by Jim » Tue, 23 May 2000 04:00:00



I am using a startup form as my primary information display for a 2200
record database.  The form contains a listbox which displays the four
fields of information for each record.  The first column is the bound
column.  This allows me to incorporate a number of control buttons on the
form that allow the user to switch form views when one particular record
in the listbox is selected.  Therefore, if the user selects one of 2200
records in the listbox, then selects the "Patient Info" control button,
the patient information form for the particular record highlighted in the
listbox opens.

My problem is that the listbox is not an ideal view of the information.  
Unlike a subform, I can not sort or filter with the listbox.  If I remove
the listbox and incorporate the subform, I can not use the control buttons
that I have included onto the form for opening other forms.

Any suggestions??

Thanks, Jim

--
Posted via CNET Help.com
http://www.help.com/

 
 
 
Top

Access Form question

Post by Tim Mills-Groninge » Wed, 24 May 2000 04:00:00



Quote:> I am using a startup form as my primary information display for a 2200
> record database.  The form contains a listbox which displays the four
> fields of information for each record.  ...

> My problem is that the listbox is not an ideal view of the information.
> Unlike a subform, I can not sort or filter with the listbox.  If I remove
> the listbox and incorporate the subform, I can not use the control buttons
> that I have included onto the form for opening other forms.

Me, I'd use a combo box and synchronize the form after update.

However, you can control the sort order of the listbox and you can have
buttons on the form react to the selected value in a subform.  You can do it
directly with [subformname].form![controlname]

hth,

--
Tim Mills-Groninger
IT Resource Center - Technology Leadership for nonprofit excellence
http://npo.net

 
 
 
Top

Access Form question

Post by Jim » Wed, 24 May 2000 04:00:00


Tim,

Thank you for the help.  The VBA line that you provided was what I
needed: "[subformname].form![controlname]".  I was trying to put the form
name in front of the subformname.

Thanks, Jim




> > I am using a startup form as my primary information display for a 2200
> > record database.  The form contains a listbox which displays the four
> > fields of information for each record.  ...

> > My problem is that the listbox is not an ideal view of the information.
> > Unlike a subform, I can not sort or filter with the listbox.  If I
remove
> > the listbox and incorporate the subform, I can not use the control
buttons
> > that I have included onto the form for opening other forms.

> Me, I'd use a combo box and synchronize the form after update.

> However, you can control the sort order of the listbox and you can have
> buttons on the form react to the selected value in a subform.  You can
do it
> directly with [subformname].form![controlname]

> hth,

> --
> Tim Mills-Groninger
> IT Resource Center - Technology Leadership for nonprofit excellence
> http://npo.net

--
Posted via CNET Help.com
http://www.help.com/
 
 
 
Top

Access Form question

Post by Mark Prest » Wed, 24 May 2000 04:00:00


Yes Jim, keep your form, but 'feed' it from a query rather than the
data table. Use a second form for QBE to build the parameters to the
query and re-run it. Link the QBE form to your main form.

On Mon, 22 May 2000 15:30:05 GMT, Jim


>I am using a startup form as my primary information display for a 2200
>record database.  The form contains a listbox which displays the four
>fields of information for each record.  The first column is the bound
>column.  This allows me to incorporate a number of control buttons on the
>form that allow the user to switch form views when one particular record
>in the listbox is selected.  Therefore, if the user selects one of 2200
>records in the listbox, then selects the "Patient Info" control button,
>the patient information form for the particular record highlighted in the
>listbox opens.

>My problem is that the listbox is not an ideal view of the information.  
>Unlike a subform, I can not sort or filter with the listbox.  If I remove
>the listbox and incorporate the subform, I can not use the control buttons
>that I have included onto the form for opening other forms.

--
Mark A Preston BSc, FIAP
The Magpie's Nest

 
 
 
Top

1. VBA Question about Access Forms

Greetings,

I am relatively new at VBA.  Here is my question.  I hava form with a text
box that has VBA code mapped to it.  How do get the text that a user enters
into the text box passed as a string to my VBA function?  I need the user's
input available as a string that I can pass along to other functions.

Thanks in advance.

Steve M. (Northern Virginia)


2. Multi-language support OpenRoad

3. Another ACCESS question about filter by form?

4. Server performance and device expansion

5. Access 2.0 question: Forms in Dialog mode

6. Recruiter: Sr. Pre-Sales Eng. for technical sales support

7. Forms 4.5 question ( Query by form)

8. text field retrieval speed

9. simple question-Summing form output-to the form?

10. VB Form not running like Access Form

11. Access forms --> Visual Basic forms

12. Convert an Microsoft Access Form to a VB Form

13. Sending data from one form to another (VBA and Access 97 form)


All times are UTC
Board index