Hi all

I have a form (frmEditAgentShifts) based on a single table. The table
in question has fields which lookup to other tables.

Another form has a button which opens the frmEditAgentShifts form and
displays information on the agent selected in the main form.

I need to be able to edit a single field in the frmEditAgentShifts form
- the field in question is displayed as a bound combobox. The combo
will drop down and displays the correct data but I cannot update the
recordset.

Can anyone help. Is it to do with the fact that the table the form is
based on has lookups.

thanks
michelle

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

you could consider adding a subform to your form where you can edit the list
or, what I do, is add a button to open the other form to edit the list. Ask
me if you need more help.


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.683 / Virus Database: 445 - Release Date: 12/05/2004