Binding a query to a textbox control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

Bit new to this, but how do you programatically bound the result of a query,
in this case a scaler to a textbox control when the form loads up?

Say
form name is frmmenu, control name is textboxincomplete, and query name is
incompletereturn

Your help will be most appreciated.

Pogas
 
In the control source of the field you can write

=DLookup("[FieldNameInTheQuery]","incompletereturn")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating authors name on text box control 2
Binding object 1
Facing problems in binding Control Source 6
Linking textboxes to a subform 2
Query: Automated filter condition extracted from a textbox 1
Summing time worked by an individual on a weekly basis 12
Passing value from unbound textbox to bound textbox 2
SubForm EVENT to use after controls are populated 1

Back
Top