Computer Science Canada

making two values in text box equal each other

Author:  gagz [ Mon Feb 21, 2005 7:29 pm ]
Post subject:  making two values in text box equal each other

im using microsoft access xp and i have two forms booking and booking 1. i have two text boxes date in each form. I need to make the value of the text box in booking 1 equal the value in date text box in the booking form.

ive so far reached :
Dim s As Integer
s = [Booking1]![DATE]

Dim p As Integer
p = [booking]![DATE]

p = s

the thing is it cannot find the forms booking 1 and booking but they exist!.... when i entered it in the name date is automatically changed to DATE so the code has found date..

any solutions?
reply back
thanks
gags

Author:  Brightguy [ Tue Feb 22, 2005 1:54 pm ]
Post subject:  Re: making two values in text box equal each other

I haven't used forms in Access that much, but if you're just trying to set the value of one text box equal to the value of another, try something like:
code:
Me.Text0 = [Form_Form1].Text0

Author:  gagz [ Thu Feb 24, 2005 12:38 pm ]
Post subject:  thanks

thanks for the help it worked Very Happy .. U R GREAT


: