Help with the contents of a text box

[bobby]

Form 1 submits information to a database.
When the button on form 1 is clicked Form2 loads.

I want a textbox in form2, to = SELECT ....... but i dont want to use vba, and cant seem to make that textbox equal a certain value by default.

Any ideas ?

 

[Mile-O]

Why do you not want to use VBA?

Anyway, =SELECT what? If you are implying SQL then you should use a domain aggregate function such as DCount or DLookup depending on what you want. These are explained within the help files.

 

[bobby]

Well, i dont want to use vba because its for a uni assignment and were supposed to be doing an ms access database - not a vb assignment.

 

[Mile-O]

Or because it would arouse suspicion?