moving data from one form to another

[mel]

i am new to access and have a basic hotel database however, the opening form checks availability by entering a date and seeing if any rooms are available but i cant get the date from the opening form to automatically appear in the third form for booking any ideas would be greatly appreciated

 

[pbaldy]

Welcome to the site. Not completely clear on what you want to do, but it sounds like:

DoCmd.OpenForm "OtherFormName"
Forms!OtherFormName.TextboxName = Me.TextboxName

 

[mel]

thanks for the quick reply as i said i am new to access do i enter this in the code of the text box i wish it to appear in

 

[pbaldy]

Presumably you have a button or something on the first form that opens the other form. If you use VBA code, you'll already have the DoCmd line, and would just add the other line. If you have a macro, you'd add a SetValue action after the OpenForm action.

 

[mel]

fantastic think ive got it thank you very much

 

[pbaldy]

No problemo; post back if you get stuck.