Can I retrieve information from a table onto a form?

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

Let's say I enter an invoice # into a form. I would like to be able to have
the date, amount, notes, etc., for that invoice (already entered into another
table) automatically appear in other boxes within the same form. Is this
possible, and if so, can you walk me through it?
 
Put a combo box on the from. Let the wizard do that for you and let it set
invoice # as the item you will look up. Then right click on the combo and go
to properties, then find the events properties. Click on the afterupdate
event, click the little button out to the right, and start the code builder.
Type:
Me.filter = "[invoice #] = """ & me.combo# & """"
Me.filteron = true
The combo# will be listed, like combo12 or combo2
 
Back
Top