Author Topic: Listbox In Form in Access  (Read 1909 times)

0 Members and 1 Guest are viewing this topic.

Peter Jamtgaard

  • Guest
Listbox In Form in Access
« on: January 15, 2007, 06:04:26 PM »
Hey group

I was wondering if any of you could help me with a form in Access.

I have a field in my database for the record description.

I want to have a list box in the dialog where I can select the description and have the form switch to that record

Do any of you have anything like that?

Peter


Dave R

  • Guest
Re: Listbox In Form in Access
« Reply #1 on: January 16, 2007, 08:15:00 AM »
In the OnChange event of the listbox set the form filter to the description field then do a Refresh on the form. This will filter the recordset for the record(s) that match the description.

Hey group

I was wondering if any of you could help me with a form in Access.

I have a field in my database for the record description.

I want to have a list box in the dialog where I can select the description and have the form switch to that record

Do any of you have anything like that?

Peter