Recordest problem (1 Viewer)

[RpbertS]

I believe this is the right forum but am not sure, heres the question:

I have a form with one text box, one combo box and one button, basically the user picks a choice from the combo box then types in what he wants to add in the text box..the problem is you can't choose a item from the combo box it says"record set not updateable" I've looked this up and I guess it should be set at a Dynasets. Im new to access so this is confusing me. If anyone could help get me started or move me along quicker it would be appreciated

thanks for the time,
Rpb

 

[jfi]

Is this form based on a query or on a table?

 

[RpbertS]

This is currently based from a table. I am about to try running it from a query though.

Rbp

 

[RpbertS]

no luck with running it from the query, if anyone could help it would be appreciated.


thanks again,
Rpb

 

[iommi]

Cant you just have a column-combo, where the user chooses a value? Must the combo pic up its items (selectable values) from an underlying table?

I dont know if i have understood correctly, but when you post the values, you cannot update the recordset. Solution: Use dynaset.

dbengine(0)(0). openrecordset("your select statement or table", dbopendynaset)

THis should work.

(Iommi)