Access how do i create a search box,then use the info to pre fill

  • Thread starter Thread starter shedendcfc
  • Start date Start date
S

shedendcfc

How do i create a serch box that finds an account number, then using that
account number auto fill a form with the persons name and address
 
Put a combo box on your form. Allow the wizard to do that for you and select
account number as the number it looks up. Then right click on the combo to
get properties, go to events, select the afterupdate event and click the
little button out to the right, start the code builder. Type:
Me.Filter = "[account#] = """ & Me.combo# & """"
Me.filteron = true
The combo number will be listed, like combo10 or combo 22
 
Back
Top