L
Linda RQ
Hi Everyone,
Access 2003. ComboBox with physician names. To add a physician, double
clicking opens up the physician form.
Problem
If I enter a name that is not on the list to my combo box, I get a prompt to
double click to add the physician. If I do that and enter the physician as
a new record then click my Ok button, I get this message "You must save the
current record before you run the requery action." I click ok... then when
back on my main form, the new physician name doesn't show up in the list to
select unless I exit the database and reopen.
If I simply double click on the physician combo box and add a new record and
click ok, the physician name is in the list to select.... works perfectly
I don't understand why having typed a name not on the list would cause this
problem...What part isn't working?
The combobox is on a subform. I have it limited to list.
Properties.
Control Source-PhysID_fk
Row Source-Table/Query
Row Source-qryPhysicians
Column Count-5
Column Widths-0";0";0";0.75";0"
Bound Column-5
sql from my query
SELECT tblPhysicians.PhysLName, tblPhysicians.PhysFName,
tblPhysicians.PhysMI, [PhysLName] & ", " & [PhysFName] & " " & [PhysMI] AS
[Phys L_FName], tblPhysicians.PhysID FROM tblPhysicians ORDER BY
tblPhysicians.PhysLName;
Events
On Not in List-I am using the macro MsbBox
To add an item...Double click in field, add the name.
On Double Click- OpenForm
frmPhysicians
I have no events on the frmPhysicians
Access 2003. ComboBox with physician names. To add a physician, double
clicking opens up the physician form.
Problem
If I enter a name that is not on the list to my combo box, I get a prompt to
double click to add the physician. If I do that and enter the physician as
a new record then click my Ok button, I get this message "You must save the
current record before you run the requery action." I click ok... then when
back on my main form, the new physician name doesn't show up in the list to
select unless I exit the database and reopen.
If I simply double click on the physician combo box and add a new record and
click ok, the physician name is in the list to select.... works perfectly
I don't understand why having typed a name not on the list would cause this
problem...What part isn't working?
The combobox is on a subform. I have it limited to list.
Properties.
Control Source-PhysID_fk
Row Source-Table/Query
Row Source-qryPhysicians
Column Count-5
Column Widths-0";0";0";0.75";0"
Bound Column-5
sql from my query
SELECT tblPhysicians.PhysLName, tblPhysicians.PhysFName,
tblPhysicians.PhysMI, [PhysLName] & ", " & [PhysFName] & " " & [PhysMI] AS
[Phys L_FName], tblPhysicians.PhysID FROM tblPhysicians ORDER BY
tblPhysicians.PhysLName;
Events
On Not in List-I am using the macro MsbBox
To add an item...Double click in field, add the name.
On Double Click- OpenForm
frmPhysicians
I have no events on the frmPhysicians