select statment to give updateable recordset

[livvie]

I am using the value selected in a combobox to populate a form and I then need to be able to edit one of the fields but the recordset is not updateable how do I make it updateable.

 

[maxmangion]

what kind of relationship do you have on your the query which your form is bounded too ? Make sure that on the properties of the form, the recordtype is set to dynaset.

 

[livvie]

what kind of relationship do you have on your the query which your form is bounded too ? Make sure that on the properties of the form, the recordtype is set to dynaset.

I'm using Access 2003 .adp so the recordtype is Updateable recordset. I can update it fine if I dont use the combo to set the record source. The form is bound to a table.

 

[maxmangion]

is your combo bounded to a particular field ?

Also, ideally you should bound a form to a Query and not directly to a Table.

 

[livvie]

is your combo bounded to a particular field ?

Also, ideally you should bound a form to a Query and not directly to a Table.

No the combo is unbound and this is it's rowsource
SELECT DISTINCT TOP 20000 Partno FROM tblctest WHERE (Partno <> ' ') ORDER BY Partno.
What is teh advantage of binding the form to a query

 

[maxmangion]

If you use a query you can make use of 'criteria' thus you can limit the number of records which loads into your form. This means that if you have a table with 10000 records and you base the form on it, your form is going to take longer to load and this will affect your db performace.

However, this issue has been discussed several times on this forum, therefore a quick search, may give more detailed information about the matter.

 

[livvie]

If you use a query you can make use of 'criteria' thus you can limit the number of records which loads into your form. This means that if you have a table with 10000 records and you base the form on it, your form is going to take longer to load and this will affect your db performace.

However, this issue has been discussed several times on this forum, therefore a quick search, may give more detailed information about the matter.

Thanks I'll look into it so 'cos that would suite me perfect for some of my other forms too. Will it solve this problem.

 

[maxmangion]

well to be honest, i am not sure if such change will address your current problem, but better address such an issue now before you go further with your form, so that you would avoid double working.