Forms that create forms

[jaymack70]

I am relatively new to Access, so my apologies for possibly asking dumb questions.



I've created a form called "Initial Customer Contact Form." In that form, I have two buttons, both with the intended function of creating related forms. I want these new forms to bring over data, including the primary key, from the record on the main form. For example, I have a "Sales Form" button. When the button is used it would create a Sales record, which would share with the main form the customer's first and last names, a few other pieces of data, and the primary key.

As it is, all the forms I've created are associated with their own tables.

Not sure if the forms should share the same table and create a relationship between them using the primary key (Customer ID) or they should have separate tables with the same relationship.

Again, my apologies if I have not communicated my situation very well. Thank you for the help.

[pbaldy]

What is your data structure? Creating forms on the fly would be exceedingly rare. It sounds like you may have tables/forms for each customer, which would be a mistake.

[jaymack70]

I guess my error was stating that my process was "creating related forms" when I should have stated "generating related forms," since all the forms have been created.

What I am looking to do is have three of my forms share certain data from the active record and its database. For example, I open the main form and create a record of the inquiry. If the prospective customer returns to make a purchase, I reopen that record and use the Sales Form button to generate a Sales Record that brings over the primary key, First Name and Last Name, and a few other data points from the record in the main Contact Table.

One question, as stated previously, is should they all have separate tables or share a single table?

Structure

Contact Table - Initial Customer Contact Form (these are my primaries)

Sales Table - Sale Form

Additional Contact Table - Additional Contact Form

Occupant Table - Occupant Form

Not sure if I've clarified anything or made it worse.

[pbaldy]

You would be generating a new record on the sales form? You can use the new record argument of OpenForm and then populate fields with

Forms!SalesFormName.ControlName = Me.ControlName

replacing with the appropriate form and control names.

[jaymack70]

Yes. By clicking the Sales Form button, the Sales Form would be activated so a new sales record could be created.

[jaymack70]

Also, since I am very new to Access, where would I enter the information you provided above? Expression Builder? Thanks a million for your help.

[pbaldy]

Okay; let me know if you have trouble implementing my suggestion.

[pbaldy]

I personally only use VBA, not macros:

http://www.baldyweb.com/FirstVBA.htm

[jaymack70]

Thanks for the suggestion. What replaces the Me. portion of the code?

[pbaldy]

ControlName is replaced with the name on the first form that contains the data you want to copy to the second form.