Would like to refer to a query other than the table form is basedon.

[Brainwave Surfer]

I'd like to refer to a query that is a pass-thru query to get a
username, then in a form that is based on another table, use that
query's result to lock and unlock fields for updates.

Right now I'm trying to do that in visual basic by trying to get the
query's data directly, failed, and tried to create a bound textbox to
get the data.. I really don't care how it gets done..

any ideas? maybe I'm barking up the wrong tree?

Jim

 

[Adrian Jansen]

You cant bind an individual textbox to a query. But you can use Dlookup to
return a single result, and put that into a textbox.

me.MtTextbox = Dlookup("TableField","Table","Criteria")

Substitute your own names of course.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Brainwave Surfer]

You are a life saver... Thanks...

Jim