search and populate data into input form

  • Thread starter Thread starter Sarah G.
  • Start date Start date
S

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
 
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
 
Chris,
That works perfectly, thank you so much.
Chris said:
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
Click to expand...
 
Back
Top