Thank you for your response. Where on the reference paper is the record number the user clicked on? I thought I was to look for a record selector index, that the record selectors are part of access and not a field i created. my main form is proposal, the user can click on a find button; it fires the OnClick event procedure that has this command: DoCmd.Open Form "SearchProposal "
SearchProposal Form has a sub form named ProposalList....
User Profile
Collapse
-
Getting the record from a datasheet to display on another form
Database: customer table; orders table; quote history table
I have a form to enter the orders saves to the orders table. User wanted a "look-up" screen to search for the right order. The look-up form has fields the user fills in with criteria for query. Results are displayed in a sub-form. I need to know how to enter code to grab the record the user clicks on in the sub form and display all the data in my order form. I've tried...
No activity results to display
Show More
Leave a comment: