Help with command button / relationship in forms

[Ibero]

Hello all,

I am trying to add command button to open a new form. I want the new form to be locked into the current record only. For example, my main table has "Case Number field", which is an autonumber with a format, and i want to open a new form that adds notes for the case number being added. The notes form is based on it's own table, with 3 fields (Case number, date, and notes). Do i need a special relationship between the 2 case numbers, or anything i might be doing wrong. I have tried various relationships and data types on the Notes table for the case number field. I have been using the command button that says "based on specific record and i have linked both case numbers together, however, it dosen't seem to work, when the Notes form opens up, it's number is at 00000, or if i set it to an autonumber it start it's own. Am i not using this tool properly? Thanks in advance all!

 

[weilerdo]

If I am understanding your question correctly, You have a field on your "main form" with the case number in it. On the form you are opening you need to have a field that also has the caseID in it. If you put something like this in the Default Value property it should work for you


=[Forms]![Main form]![name of field with case id #]

 

[Ibero]

Wow, that does work great actually, thanks a lot.