TheSwamp

Code Red => VB(A) => Topic started by: Peter Jamtgaard on January 15, 2007, 06:04:26 PM

Title: Listbox In Form in Access
Post by: Peter Jamtgaard 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

Title: Re: Listbox In Form in Access
Post by: Dave R 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.

Quote from: Peter Jamtgaard 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