Sync Two related subforms (1 Viewer)

[ngsabath93]

When I try to type a new ID into the field on "Homepage" it gets a messgae: "The text you entered isn't an item in the list. Select an item from the lsit, or enter text that matched one of the listed items.
It doesnt give me the option to open a blank ClientFrm

 

[GinaWhipp]

Oh, that is what I asking before... okay, so you want a Not_In_List event. Have a look at...

http://www.dataschenk.com/newsletters/Tips/Access_Not_in_List.htm
http://www.databasedev.co.uk/multi-field-not-in-list.html

 

[ngsabath93]

I tried using the first link. Can I use this if My ClientID is a number field? Also On the homepage...how should I make this combobox? SHould I click add existing field (then choose ClientID from the table of CLientfrm)? or should I make a whole new underlying table for homepage and add a new field "clientIDMain" that will be the combobox? or should I just have the combobox unbound?

 

[GinaWhipp]

What number field? Which link are you looking at?

 

[ngsabath93]

The first link. And the ClientID is a number field

 

[GinaWhipp]

I do not see anything on that page that refers to a number field. This is a Not-In_List event that allows you to add new Clients. It opens a a Form (you create) to do so... so again what are you meaning when you ask about using a number field?

 

[ngsabath93]

ok I figured it out. However once the form opens and I fill out the blank form and close it, he form closes and then reopens diplaying all the information I just typed in. Is this normal?

 

[GinaWhipp]

It shouldn't close and then reopen. Please post the code you are using here...

 

[ngsabath93]

View attachment 5.accdb


I just attached the database, I hope that is ok. Its the same as before. Thank you again for all your help! You're truly a life saver!!

 

[GinaWhipp]

Grandkids here so will be off and on... I will look at your file as soon as I can.

 

[GinaWhipp]

I do not see it opening twice. I opened the Home Page then typed in 99 (a new Client), the Client Form opened, I entered 99 and closed the Form and it was in the list (the Client ID Combo Box). So where is it opening twice?

Side note, the button will open the ClientID Form for any Client ID entered in the Combo Box but I have to click the button for that to happen.

So what am I missing?

 

[ngsabath93]

Once you enter a new ID into the Client form, I have to click the close button twice for it to actually close

 

[GinaWhipp]

Okay I think I see the problem. The Client ID Combo Box on the Home Form need to be UNBOUND. That means no Control Source.

 

[ngsabath93]

I made it unbound, and it is still doing this

 

[ngsabath93]

Also, is it possible to make the devault value on the homepage blank? Thanks!!

 

[GinaWhipp]

For whatever reason I cannot download your attachment. Not quite sure why so please upload a new file.