Form-Combo Box-Saving value to table

[Jill]

Hello,

I have an issue I've been researching for hours!

I need to provide a list of values from a table (physicians) in a Datasheet form where it displays the default for the record but includes a combo box drop down with the available physician names (all good here). When the physician name is changed, it changes my physician table instead of the patient record (the issue).

Tables:
Physician (Fields: PhyID, PhyLastname)
Patient (Fields, ..., PhyID).

In order to display the default in the form, I have Physician.PhyLastname as the Control souce (although this is not what I want to be updated but has been the only way to display the value in the form with existing data).

Row Type source = Table/Query


I have the Row Source as a query to the Physician table pulling out both PhyID and PhyLastname (drop down works beautifully).

When I'm in the form and select a new physician name from my beautiful drop down , it changes the physician table instead of inserting the physician ID (PhyID) into the Patient table.

Any help would be so much appreciated.

Thanks, Jill

[pbaldy]

It sounds like the form should be bound only to the patients table (sounds like you're using a query with both tables). The control source of the combo should be the appropriate field in that table.

[JoelBR]

Hi, I have been looking an example how can I save unbound combo box value to the corresponding table without luck. I am using unbound combo box because I want to control the saving with a button.

Can Anyone help me with this issue or give me the correct direction?

I already have the form to get data from table, but I have some problems to save data to tables from the combo boxes and text box.