populating unbound text boxes

[shawndu]

I'm trying to populate each unbound textbox on my form. i've done something similar before but I can't remember how I did it! Each one needs to have different parameters in its query. i've tried putting the select statement in the control source of each one but I get the #Name? every time.I've tried multiple syntax variations but none seem to work! Am I simply putting the select statement in the wrong place?

Any suggestions on syntax or anything else would be helpful.

 

[BoxHead]

Shawndu,

Take a look at DLookup in Help. It sounds like that is what you're after.

If not, post back with some more specifics: examples of select statements, when you want the textboxes populated, etc.


HTH John

Use what you have,
Learn what you can,
Create what you need.

 

[shawndu]

DLookup works great when there is only one parameter but I need to include several. For example I need to retrieve a name based on date, time, and employee assigned to that person.(i'm creating a monthly/daily scheduler for appointments)Text boxes need to be populated on the opening of the form.

 

[BoxHead]

Shawndu,

DLookUp allows for multiple criteria parameters using 'AND' in the where portion of the function.



HTH John

Use what you have,
Learn what you can,
Create what you need.

 

[shawndu]

Works GREAT! Thanks alot.