Combo-boxes Won't update!!

[tflett]

I built a databse with a main form for data entry. This form has 3 subforms
and included in the subforms are combo-boxes with a table linked to them.
When I click on create new record, every field is refreshed except for the
combo-boxes, they still have the same information in the textbox.

Can anyone help???

 

[Jeff Boyce]

What is the row-source for each of the combo boxes?

If the values in the combo boxes are not changing when you go to a new
record, maybe they are not "bound" to any underlying field in the data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mirka]

I think you need to requery so the change is picked up.

 

[tflett]

The rowsource for each of the combo-boxes is as follows:

SELECT [Emp Codes].EmpCodeNum, [Emp Codes].Employer FROM [Emp Codes];
SELECT Trades.TradeID, Trades.TradeNum, Trades.TradeName FROM Trades ORDER
BY [TradeNum];
SELECT Trades.TradeID, Trades.TradeNum, Trades.TradeName FROM Trades;

 

[tflett]

I really need help with this combo box problem.
Can any one help me please???

 

[Jeff Boyce]

.... and they are "bound" to ...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

The rowsource for each of the combo-boxes is as follows:

SELECT [Emp Codes].EmpCodeNum, [Emp Codes].Employer FROM [Emp Codes];
SELECT Trades.TradeID, Trades.TradeNum, Trades.TradeName FROM Trades ORDER
BY [TradeNum];
SELECT Trades.TradeID, Trades.TradeNum, Trades.TradeName FROM Trades;

What is the row-source for each of the combo boxes?

If the values in the combo boxes are not changing when you go to a new
record, maybe they are not "bound" to any underlying field in the data?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[moshe via AccessMonster.com]

Check the control source from the combo box it should be set to the tables
primery key