Display a record in form view, based on a query

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hi all,

I need to allow a very simple way for multiple user to
display a previously entered record, while in form view,
based on entering data.

What I am thinking is that they could select a button I
create, placed on the form that would display a field
where they either type or select from a pull down list,
what invoice they want to find. Once the invoice number
is typed and they press enter, the form record is diplayed
on the screen for editing, priting etc.

I do know about filters, but would like to do the same
task with a button control. I don't know if this can be
done and don't know where to look in help.

Any suggestions would be greatly appreciated. Thanks.
 
You are describing the behavior of a ComboBox, able to drop down a list of
the invoices in your table, or accept typed input into the box if the users
know the invoice they are looking for.

Put a combobox control on your form, and bind it to the invoice field in
your table. If you are unfamiliar with this, the combobox wizard will help
you get it there. Follow the wizard's guidance to create a combobox that
displays a record on a form based on the user's choice (or words to that
effect).

HTH,

Paul
 
Back
Top