Competent Performer
Windows 10 
Access 2010 64bit
I have a form that shown drivers race data. A button on that form bring up a report of driver details.
The problem I a having is my where clause brings up a prompt to enter the drivers ID. I would like to eliminate the prompt and open the report directly.
My code is, Where=Any help please.Code:="[DriverID]=" & "[DriverHistoryF].[DriverID]"
Jim O
Access Developer
Windows 7 32bit Access 2013
Perhaps:
WHERE "[DriverID]=" & Me.[DriverID]
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Master of Nothing
Windows XP Access 2010 32bit
Not a lot to go on.....
One thing is that the reference to [DriverID] should not be in quotes - the quotes turn the reference to a string.
Another is that you are referencing the form wrong. A fully qualified reference to a control on a form would be: Forms![DriverHistoryF].[DriverID]
Maybe try
Code:"Where [DriverID]=" & Forms![DriverHistoryF].[DriverID]
Competent Performer
Windows 10 Access 2010 64bit
ssanfu,
Thank you for the help. That works fine.
Jim O
Master of Nothing
Windows XP Access 2010 32bit
Happy to help....
Expression Meanings-Hi What Does the following Expression Mean?
Expression to complex in query expression (switch)
Posting Permissions
Reply With Quote