Button to open form to new form with pre-selected fields

[sstiebinger]

I'm new to access, so thank you for taking the time to read and answer.

I've got a table for contacts including:
ID
FirstName
LastName
Etc.

I've got a table for appointments including:
ID
Subject
ContactID - 1 to many relationship to Contacts.ID
Etc

I have a form for viewing/editing contacts, and on that form I want a button to open a new form to Add an Appointment for the currently displayed contact; so the appointments form will open to a new record, but with ContactID already populated from the current form's ID field...

I simply can't figure out how to do this... I've tried several things based on Google, but I end up with either a blank for with nothing selected for ContactID, or the form opens to an existing record, I simply can't get it to open to a new record for the ContactID


I can post example DB if that helps.

If I add the appointments form as a subform to contacts, it works as I want so it seems there should be a way to separate this...

[pbaldy]

Along the lines of

DoCmd.OpenForm "NewForm"
Forms!NewForm.ContactID = Me.ContactID

If appropriate, you could also make the default value property of the textbox on the new form refer to the first form.

[sstiebinger]

That took care of it... I was using some similar code from other google searches, but this one worked where those did not.
Thank you for the prompt response!

[sstiebinger]

Actually, I spoke too soon.... While using this code, when there are no appointments in the appointments table, it opens a new appointment with the current user...
However once an appointment is created, it then opens the EXISTING appointment and CHANGES the user for the existing appointment... this is not desired behavior.

[sstiebinger]

Sorry, changed the new form Data Entry property to Yes and that fixed it...
Sorry, still learning Access.

[sstiebinger]

Hmm, that takes care of entering new details, but by setting the form to Data Entry the user can no longer review previous appointments tied to that customer...
Is there a way to do this where it defaults to a new record, but allows viewing other records tied to the same contact? Or must I create a separate form for viewing vs entering?

[sstiebinger]

DoCmd.GoToRecord acDataForm, "frmAppointments", acNewRec

This line opens the form at a new record without having the data entry set to yes, but how can I have the filter for that new form be set to whatever the ContactID is?

[sstiebinger]

Marking as solved since this is a new issue, opened a new thread.

[pbaldy]

Sorry, missed the followup question. Would this have helped?

BaldyWeb wherecondition

[sstiebinger]

I actually did reference that, thanks!

[pbaldy]

Glad you got it sorted out!