I just want to call a query by customer ID, and i want to chose the Cus ID from Customer Table.
Novice
Windows 10 
Office 365
I just want to call a query by customer ID, and i want to chose the Cus ID from Customer Table.
Access Developer
Windows 10 Access 2016
I don't understand.Originally Posted by Ihthisham
Give us a bit more detail about your table and what you are trying to do
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Access Developer
Windows 10 Access 2016
EDIT:
My original post was made in error.
Last edited by Bob Fitz; 05-16-2022 at 07:10 AM.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
VIP
Windows 10 Access 2010 32bit
Bind a form or report to table or query. Apply filter to form or report. This can be done when form or report opens or after opening. Use code or ribbon tools. Review http://allenbrowne.com/ser-62.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Virtually Inert Person
Windows 10 Access 2016
Bob, just replace post text with something if you're still able to edit at this point.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
If you don't reference a form control as explained by June your other option is using a dLookup().
Cheers,
on double click item in listbox (multi-select) call sub with variable of item that has been clicked
Pass VBA variable to Public Variable and pass to Access 2007 Append Query attached to a form.
Assign and call variable from table
Posting Permissions
Reply With Quote