Form programing

[Jesus Christ]

Thouest is using access 2002, would like to know how to
use querydef to make temparary querys and search for a
user input value in a text field and make the resulting
recordset the current value of thy form.

Thy assistance is appreciated..

Jesus.

 

[Joshua A. Booker]

Hope fully that is your real name.

Anyway, you can set the form's controlsource Property to a query that looks
at text box for it's criteria like this:

SELECT TableName.* FROM TableName WHERE FieldName =
Forms!FormName!TextBoxName

Where 'TableName', 'PKFieldName', 'FormName', and 'TextBoxName' are the
names of your objects respectively.

Then in the AfterUpdate event of the textbox requery the form like this:

Me.Requery

God Bless,
Josh

 

[PC Datasheet]

And he said "Thou shalt not take the name of thy Lord thy God in vain".

 

[Randall Arnold]

The REAL Jesus would know how proper spelling and grammar.

; )

Randall Arnold