Grandchester
Registered User.
- Local time
- Today, 03:31
- Joined
- Jan 26, 2001
- Messages
- 20
Hi all. The best way to explain this is to show an example:
Me.RecordSource = "SELECT tblMain.ProductCode, tblMain.Name, tblMain.[NLGI Grade], tblMain.Color FROM tblMain WHERE (((tblMain.ProductCode)=" & varSearchData1 & "));"
The key to this is the "varSearchData1" variable. I have this set on my "Load Form" action, but it still prompts me for a parameter. I already established the value of "varSearchData1", but it still prompts me for it. Any ideas how to do this without getting promted? Thanks. Peace
Grandy
Me.RecordSource = "SELECT tblMain.ProductCode, tblMain.Name, tblMain.[NLGI Grade], tblMain.Color FROM tblMain WHERE (((tblMain.ProductCode)=" & varSearchData1 & "));"
The key to this is the "varSearchData1" variable. I have this set on my "Load Form" action, but it still prompts me for a parameter. I already established the value of "varSearchData1", but it still prompts me for it. Any ideas how to do this without getting promted? Thanks. Peace
Grandy