create new record on open?

[kelsita_05]

I'm a little rusty, so thanks for your patience.

I'm adding a new form (Form2) to a database I made a couple years ago. The form is based on a query. It has one subform. All of this is working great.

I open Form2 from a command button on another form (Form1) - I have some linked fields that are showing up correctly. This works great when a linked record exists (which I entered by opening Form2 manually). However, when a linked record hasn't been made yet, Form2 is blank. As in grey screen blank - no page controls, no nothing.

How can I get it to create a new record when one does not exist? I have another form setup very similarly (Form3), which also opens from a command button on Form1, but it is based on a single table. That works fine - if a record exists, Form3 shows it, but if there is no record, it opens so a new record can be entered.

Thanks for your help!

 

[kelsita_05]

scratch that - I have a lot more issues than I though. I'll be back when I figure out what I did!

 

[kelsita_05]

I am an idiot - had no reason to base it on a query instead of the table. problems are all solved.