Hi everyone.
My name is Dan, and I am a complete Access newbie.
I am proficient in Excel and VBA, so I thought learning access would be a breeze. I was SO wrong! I am using MSAccess 2007
I have a problem, that I thought someone may be able to help me with.
I have scoured the internet, Access help file and MSKB/MSDN and torn apart the Northwind DB, but nothing is assisting me with this specific problem.
I am trying to generate a purchase order report.
I have 2 tables.
Table 1 = Orders (primary key is 'poID').
Table 2 = Items (primary key is 'ID' with another field 'PO' linked to Orders.[poID]).
I have a command button on the form which allows the data entry.
('Orders' details in text boxes, and 'Items' in a subform table layout).
The command button opens a report I have set up.
I have tried numerous things in order to filter the report. (setting the recordsource straight to the linked tables, which is what I thought would be the most straight forward way. I have created a seperate query that lists all required info in the single row, including all primary keys.)
The filter I have in the command button (which opens with a macro), is
="[poID] = " & [poID]
Every time, I generate an error; MS Access DB could not find [poID]=1
This would indicate to me, that the [poID] field on the userform is ok. But the poID field in the report query is somehow missing or misnamed!?
Am I missing something guys? Any assistance you could give would be HUGELY appreciated, as I am on a bit of a deadline with this little project...
Cheers,
Dan.
My name is Dan, and I am a complete Access newbie.
I am proficient in Excel and VBA, so I thought learning access would be a breeze. I was SO wrong! I am using MSAccess 2007
I have a problem, that I thought someone may be able to help me with.
I have scoured the internet, Access help file and MSKB/MSDN and torn apart the Northwind DB, but nothing is assisting me with this specific problem.
I am trying to generate a purchase order report.
I have 2 tables.
Table 1 = Orders (primary key is 'poID').
Table 2 = Items (primary key is 'ID' with another field 'PO' linked to Orders.[poID]).
I have a command button on the form which allows the data entry.
('Orders' details in text boxes, and 'Items' in a subform table layout).
The command button opens a report I have set up.
I have tried numerous things in order to filter the report. (setting the recordsource straight to the linked tables, which is what I thought would be the most straight forward way. I have created a seperate query that lists all required info in the single row, including all primary keys.)
The filter I have in the command button (which opens with a macro), is
="[poID] = " & [poID]
Every time, I generate an error; MS Access DB could not find [poID]=1
This would indicate to me, that the [poID] field on the userform is ok. But the poID field in the report query is somehow missing or misnamed!?
Am I missing something guys? Any assistance you could give would be HUGELY appreciated, as I am on a bit of a deadline with this little project...
Cheers,
Dan.
