search and populate data into input form

[Sarah G.]

Hi,

I have an input form (formA and subform B) which are invoice and invoice
detail. Once I entered the data, they will store in two tables which are
invoice and invoice detail. What I want to do is that search one of the
invoices, and the invoice and invoice detail will be populated to this input
form, then user can either modify or delete it. Would that be possible?
Because if I tried to enter the invoice again, it tells me I cannot enter
duplicate record. Right now I have to use seperate search form to complete
it, it's inconvenience for user to use.

Any idea would be greatly appreciated.

Sarah

 

[Chris]

Hi, Sarah.

Open your form in design mode. Turn on the wizard, then
create a combo box. Select the option that you want it to
go to an existing record based on your selection.

Chris

 

[Sarah G.]

Chris,
That works perfectly, thank you so much.

Hi, Sarah.

Open your form in design mode. Turn on the wizard, then
create a combo box. Select the option that you want it to
go to an existing record based on your selection.

Chris