Runtime Error 3079 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Runtime Error 3079

Michelle Mayo

16 months ago

This button has worked the entire time of my database until a couple of weeks ago...

I'm getting a runtime error when I click on a button that is supposed to take me to another form.
"the specified field 'id' could refer to more than one table listed in the FROM clause of your SQL statement"

When I click on debug it goes to the VBA screen.
This is what is highlighted:

Private Sub RequestsButton_Click()
DoCmd.OpenForm "RequestListF", , , "id=" & ID
End Sub

	Sami Shamma @Reply 16 months ago
Can you run RequestListF directly from the Navigation pane?

	Michelle Mayo OP @Reply 16 months ago
Yes

	Michelle Mayo OP @Reply 16 months ago
BTW, i'm clueless when it comes to VBA and programming language :)

	Adam Schwanz @Reply 16 months ago
That's usually because you made a query like Customers and Invoices, CustomerID is in both of them, and you brought CustomerID into the query for both tables (Thus creating a CustomerT.CustomerID and a InvoiceT.CustomerID). Try something like `DoCmd.OpenForm "RequestListF", , , "CustomerT.id=" & ID` Replace CustomerT with a table actually used in the record source of that form.

	Kevin Robertson @Reply 16 months ago
Is RequestListF based on a Query with multiple tables?

	Michelle Mayo OP @Reply 16 months ago
Thank you...that worked! :)

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

Next Unseen

New Feature: Comment Live View