Opening order form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Opening order form

Roger Strate

2 years ago

I have a list box on my main form to open an order form directly to the specific order related to the item in the list box (named "InvoicesNotPaidList". The event works (it opens the order form but does not open to the specific order ID. Here is the command I use to open:
DoCmd.OpenForm "OrderF", , , "CustomerID=" & InvoicesNotPaidList
Any suggestions?
Thanks

	Kevin Robertson @Reply 2 years ago
Is the CustomerID in the first column of the listbox? If not, I suspect it isn't, you need to reference the column of the listbox. If the CustomerID is in the second column: `InvoicesNotPaidList.Column(1)`

	Roger Strate OP @Reply 2 years ago
Thank you Kevin, that worked. OrderID was in column 4 (woops!)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View