Autopopulate using forms

  • Thread starter Thread starter Kels
  • Start date Start date
K

Kels

Hi, I have the following tables set up;

Contacts / Delegates - storing information on delegates
Event - Storing event names
Payment Methods - Showing payment methods
Payments - Showing payments made by delegates

What I have created is a booking form, however, when I use a combo box to
look up a delegate I want the rest of the form to popular their information
from the Contact / Delegates table - selected information that is.

How do I do this?
 
Put a combo box on your form (let the wizard do that for you) and select the
file you want to use to populate the form, probably a contact name,
delegate, or whatever. Right click on the combo box and go to properties.
Under events, click on the afterupdate event, then click the little button
out to the right. When it asks you what you want, start the code builder and
type:
Me.filter = "[contact] = """ & Me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo12 or combo18.
 
Back
Top