Form with query field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am really new to access and VB so I really could use some help on this one.
I have a simple database that keeps track of transations for a small group of
employees. I want to create a form that will contain the following.
1.) A text box at the top where I can enter the number of a PO.
2.) A button next to the "po" text box that will query only the transations
of the PO number I entered into the text box.
3.) At the bottom of the form I would like to have about ten fields be
populated with the information about this transations. This information was
first entered in another form in the database by the employee. I just need to
be able to double-check their work and make changes to the information if it
is need or something is missing. I don't if I would need a subform for this
or if it could just be on the same form as the text box.

Thank you very much for any help on this.
Paul
 
For the first two questions I think you could use a combo box instead of a
text box. Use the Combo Box Wizard, and choose the option that suits your
needs. You won't need a button, since the code runs as soon as the combo box
is updated (or maybe when you leave the combo box, I can't quite recall). I
don't know enough about your database to be specific about the third
question, but I would think you should have something like a table for
Employees, a table for POs, and a table for PO line items. If you post your
database structure it would be possible to advise on how best to accomplish
what you need in terms of ability to edit records, but the details will
depend on how you are using the database. In general the PO line items
should probably be in a different table than the PO number, so you would use
a subform to work with the line items probided you have a proper relationship
established between the different tables.
Thanksgiving holiday coming, so don't count too heavily on a reply from
anybody here anytime soon. Go ahead and post, of course, but delays in
responding are certainly possible.
 
Back
Top