Search results

This code works. Opens to ContactDetail_frm new record with T1_FirstName_fld with focus. DoCmd.OpenForm "ContactDetail_frm", acNormal, "", "1=0" On Error Resume Next DoCmd.SearchForRecord , "", acFirst, "[ContactID]=" & Nz(DMax("[ContactID]", Form.RecordSource), 0)...

I have a Tab Group on ContactDetail_frm which always opens to tab 0 with focus set to contact search combo box...I can live with this fact, just would of liked it to open from this form when button click with Tab 0 FirstName_fld with focus.

Tab order not going to work in my case. :oops:

Ok, I'll try that.

I have not restricted users from adding new records, I just would like the form to open on a new record with FirstName_fld with focus.

DoCmd.OpenForm "ContactDetail_frm", acNormal, "", "1=0", , acDialog Forms("ContactDetail_frm").T1_FirstName_fld.SetFocus Opens to new form, focus not set to FirstName_fld. When I close form I get error "... Cannot find the referenced form 'ContactDetail_frm'."

Good call, I had a typo. Error gone. Form opened just not on new. Getting closer. Looking into it now.

I get "Application-defined or object-defined error"

Contact_frm is a split form with a button "Add Contact" DoCmd.OpenForm "ContactDetail_frm", acNormal, "", "1=0", , acDialog when clicked it opens ContactDetail_frm. In ContactDetail_frm is a Private Sub NewContact_cmd_Click DoCmd.GoToRecord , "", acNewRecDoCmd.GoToControl "FirstName_fld"...

<SOLVED - See Post #20> I have a form called Contact_frm with a button named NewContact_cmd. I'd like to click the button and open ContactDetail_frm calling a Private Sub NewContact_cmd_Click in ContactDetail_frm. Form: Contact_frm Form: ContactDetail_frm Button: NewContact_cmd Private...

Thanks, I'll take a look at it.

I downloaded your demo file and have been looking at it. I am not fully understanding what's going on. Could you elaborate a bit on the theory of this approach and how I could implement it?

Found this on answers.microsoft.com Scottgem MVP | Volunteer Moderator | Article Author Replied on May 20, 2018 This is an issue with using Continuous form or datasheet view forms. Those form modes are really ONE set of controls repeated multiple times. So when you change one control it...

Thank you for explaining, makes sense.

I do! Why or how is this expected behavior? Can share some insight?

<SOLVED - This is an issue with using Continuous form or datasheet view forms. Those form modes are really ONE set of controls repeated multiple times. So when you change one control it affects all rows. For example: If you have cascading combos with your Car makes and Models. You chose Ford in...

Yes, I definitely used the wrong save there. Thank you for pointing it out. I'm trying and learning as I go along. The last time I used Access was in the early 2000s. I only picked it back up a month ago.

This is a really nice and functional address book. Definitely going to be peaking under the hood on this one.

Thanks for the code modifications. A great example of a similar effect of tabs with just buttons. And it ran faster with better transitions between screens.

Oh, I think see what you're saying. It seems, Contact_tbl would be the junction table between Company and ContactType? One Company with many Contacts and one ContactType with many Contacts. I may be wrong, cause I have never worked with a many-to-many relationship.