New Related Tables Records

  • Thread starter Thread starter magmike
  • Start date Start date
M

magmike

Concerning my forms, I have buttons that will open a second form with
information related to the record on the first form.

For example, on a contact record, one might push the "Letters" button
and see the letters sent to the contact in the past. I have
navigational buttons on the form as well. However, when the 'New
Record" button is pushed, it is necesary to select the contact again.
How can I program the new record button to create a new record with
the contact already filled out? The contact field in the related table
is actually the id, but displays the company name instead.

Thanks!
 
Instead of popping open a second form, consider embedding that second
(related) form as a subform on the first (main) form.

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/








- Show quoted text -
Click to expand...

There are many of these things and it wouldn't make sense to do that.
We track a lot of different data. We couldn't fit it all on one form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Regarding Forms and Forms representing Related Table Data 7
Form/Subform 8
Radio Buttons on Continuous Forms 5
Using Collect Data with Related Tables 3
Access2003-record design 6
Pop-up form that creates record that links 1:1 to main form 0
Create a New Contact Button Macro in Subform 3

Back
Top