Record Selection

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

Guest

I have a form that displays all the Purchase Orders for a given Vendor.
Among the columns are VendorNum and PONum. I would like to be able to have
the user select one of the records, then click a button that would pull up
the details of the PO on the selected record. Is something like this
possible?

I assume that there would be some coding behind the button click and I
believe I can deal with that. If there is more beyond that, please provide
an example. Thanks.
 
Martin,
You can just use a couple of unbound combo boxes on the main form. The
first combobox allows selection of any Vendor, and the second selects any
PONums associated with that Vendor.
In a subform on that form, you can display the PO info associated/linked
to the value of the second combo.
 
If I am following you correctly, the user would need to know the PO Number to
search for. What I would like to do is to have the user select from the list
of POs that are displayed (by selecting the desired record from the list) and
then click a button to execute the query/form into the PODetail table. The
thing is I cannot see any way to be able to "read" the value of the PONumber
column from the row the user selects.

For example, if my current form has the following data with each line a
record showing in the current form:
VendorNum PONumber
234 65432
234 34567
234 78901

If the user selects Record 2 and then clicks the appropriate button, I would
like to have the script pick up the value 34567 to then query the PODetail
table and display the results with another form.

I apologize if my original statement was not clear. Thanks for the help.
 
Back
Top