T
Tom Starks
Hello! I've got a series of dropdown list fields in my
database that are populated by the value in another field.
This was easy enough to do by creating specific field
queries using the value of the other field combined with a
requery command in the "after update" event. But I'm lost
on how to do it on a data access page.
On the client-side page, the "where" part of my SQL
statement looks like this:
WHERE ((MessageTypes.MessageType=forms!MainForm!combo34));
Where "combo34" is the dropdown list field that I'm basing
the query on. Well, I've tried the same thing using this:
WHERE ((MessageTypes.MessageType=DataAccessPages!
DataEntryForm!DropdownList_17));
but it doesn't work worth squat. Any suggestions out
there - heck, I'm willing to entertain ANY way of doing it
at this point.
Thanks for any and all suggestions. Have a great weekend,
Tom Starks
Email: Remove the "nospam's" from the address to get my
true email address: nospam_tomheritage2k2 at yahoo dot
com_nospam.
database that are populated by the value in another field.
This was easy enough to do by creating specific field
queries using the value of the other field combined with a
requery command in the "after update" event. But I'm lost
on how to do it on a data access page.
On the client-side page, the "where" part of my SQL
statement looks like this:
WHERE ((MessageTypes.MessageType=forms!MainForm!combo34));
Where "combo34" is the dropdown list field that I'm basing
the query on. Well, I've tried the same thing using this:
WHERE ((MessageTypes.MessageType=DataAccessPages!
DataEntryForm!DropdownList_17));
but it doesn't work worth squat. Any suggestions out
there - heck, I'm willing to entertain ANY way of doing it
at this point.
Thanks for any and all suggestions. Have a great weekend,
Tom Starks
Email: Remove the "nospam's" from the address to get my
true email address: nospam_tomheritage2k2 at yahoo dot
com_nospam.