When adding new record, not recording id from parent table.

[bratneedshelppls]

Hi, I would really appreciate some help please.

I have a form where you select the client name from an unbound cmbbox. Then user can update a new activity for the client in the subform. After I save it, the client id (from the activity table) which should correspond to the client id from the parent table, is blank. How do I populate the client id in the activity table when I add a new record please?

Also, I have another form the uses a combo box. I would like the combo box to be blank after a user selects a client. The client is populated in another field after the selection is made but how do I make the combo box show blank until user clicks on it to select another client please.



code.zip

[June7]

1. If this is a form/subform arrangement and Master/Child links are set, primary key ID should automatically save into dependent record without any code.

2. If combobox is UNBOUND, simply Me.comboboxname = Null - real trick is figuring out what event to put code into.

If you want to provide db for analysis, follow instructions at bottom of my post.

[bratneedshelppls]

Thank you, I've attached the db.

THere's another thing i'm trying to do which I have no idea how to do. In the clients table, let's say we have a husband and wife listed and they each have a different id. They will have a familyid to link them. On the client form, I have a tab which will show the activities of the client. I would like that tab to show all the activities for the husband and wife for the one family id. So if look up Bob, I will see all the activities that have been entered under his name and his wife's. Similarly, if I look up his wife, I'd like to view all the activities entered for her and her husband. The purpose is to not have to enter a note twice, under both names.

I am very greatful for any help you can give me here. I've been researching and not coming up with solutions.

Thank you,
Tess

[ssanfu]

Welcome to the forum.


The first thing I would do is convert ALL macros to VBA code. I quit scripting when Excel added VBA programming. (many, many, many years ago)


You could try using the sub form BEFORE UPDATE event.
Set the sub form ClientID_FK field/control to the main form unbound combo box's ClientID_PK field/control.

Or do as Jane7 suggests and post your dB.


Edit: too late........ again!

[ssanfu]

Items to fix: "Date" (table Opportunities) is a reserved word in Access.
Many objects have spaces in the names.
Should not use special characters in object names (tables Business Partners, Relationships & Clients---> E-Mail)
You have a lot of Look up FIELDS in the tables. Should not use Look up FIELDS in tables.

The PK fields in 2 tables are linked to the same field in table Clients. It looks like the Business Partners PK field should be linked to the BusinessPartnerID FK field in table Clients?


I am not sure how you are linking a husband and wife to get a FamilyID..... have to think about this.

[bratneedshelppls]

Hi Steve,
I'll fix the spaces and special characters and look up fields.

Yes, the Businesspartner pk should link to the businesspartneid in table clients.

I guess I have lots to fix.

Thanks for your help.