Form ?

[Guest]

I have a form with an input box. After I hit the Ok key on the form I want a
query to run using the data from the input box and display the results on the
form in other text boxes. How do you perform this?

 

[Guest]

Check this link for one example

http://www.mvps.org/access/forms/frm0009.htm

 

[Guest]

Ok, I got a textbox called cancon that I put a number into and want it to
update another field with the following VIN from the contract table. Nothing
is happening on the ViN field when i put a value in the cancon field on the
form? help

Private Sub VIN_BeforeUpdate(Cancel As Integer)
Dim varX As Variant
varX = DLookup("[VIN]", "contract", "[Contract number] =" _
& Forms![Form1]!cancon)
End Sub

 

[Guest]

Am I thinking correctly that as soon as I enter something in the cancon
field, press the enter key, the VIN field should automatically get updated?