-----------------------------------

gagz

Mon Feb 21, 2005 7:29 pm


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


-----------------------------------

Brightguy

Tue Feb 22, 2005 1:54 pm


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:
Me.Text0 = [Form_Form1].Text0


-----------------------------------

gagz

Thu Feb 24, 2005 12:38 pm


thanks

-----------------------------------

thanks for the help it worked  :D .. U R GREAT