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

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
 
G

golfinray

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
Auto fill user name 8
Search for a record by typing in a text box 3
Auto Fill Fields when listbox option selected - access 2007 2
Including a memo field when doing a search 1
Auto-Fill a Form 2
count number in field 5
Need to create a search based on a specific field 3

Top