using fields from a table on a form

[jrollings]

i have a field called case number and i have several forms that relate to this number, what im trying to do is bring the case number from my clients form to the other forms with a command button that opens the other forms so the user does not have to enter it in, also after they have entered all the data they need, to the case number needs to be written to the tables of the other forms. i hope this is clear enough thanx in advance

Justin

 

[RichO]

If the form containing the case number is open at the time, you can simply take that value right from the form with:

[Forms]![NameOfForm]![NameOfTextBox]

 

[jrollings]

the only reason i want to pull it form the table is because i still want to enter in information after the initial creation of the record. for eaxample when i finish entering a new client and i donr know all the info i want to be able to later retrieve that information and finish the entry

thanx for the help
Justin

 

[Ukraine82]

I think you better off using a combo box.

Take a look at the attachment file.

hth,
Michael

 

[jrollings]

that was the first this i tried but never got it to work so i tried with just text boxes but i think this will work beautifully, my only other question is does it have ot be in a subform?