Prev: DoCmd.RunSQL combobox column
Next: Question about finding specific record on a Form linked to a table
From: Dorian on 10 Dec 2009 18:55
What would cause the following:
I execute
DoCmd.ApplyFilter , "[TicketNo] = " & Me!GetTicket
and get an error:
Enter Parameter Value
TicketNo
Error looks like I'm executing a query and it is prompting for a parameter
Me!GetTicket should have a valid value in it
I appear to be positioned on the 'Autonum' row.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
From: Dirk Goldgar on 10 Dec 2009 19:38
"Dorian" <Dorian(a)discussions.microsoft.com> wrote in message
news:02D89564-E8DB-4790-AAEE-0264EEB07127(a)microsoft.com...
> What would cause the following:
> I execute
> DoCmd.ApplyFilter , "[TicketNo] = " & Me!GetTicket
> and get an error:
> Enter Parameter Value
> TicketNo
> Error looks like I'm executing a query and it is prompting for a parameter
> Me!GetTicket should have a valid value in it
> I appear to be positioned on the 'Autonum' row.


If it's prompting you for TicketNo, then TicketNo is the name that it
doesn't recognize. Is that actually the name of a field in the form's
recordsource? If it is the name of a control on the form, but the field in
the recordsource has a different name, it won't be recognized.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 | 
Pages: 1
Prev: DoCmd.RunSQL combobox column
Next: Question about finding specific record on a Form linked to a table