combo boxes are locked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have made a problem for myself.
I have a form with a LOT of tables all mixed into it. There are loads of
controls too which are all bound to fields in various tables. I want to be
able to have a link on my switchboard which will allow me to only add new
information and then another seperate link which will only allow edits to
existing information. I had it all working. but then i changed some thigns
and it all fell apart. My 'add new' link on my switchboard is working fine.
so i copied the form and called it 'Edit Details'. so i now have 2 main
forms, one called 'Edit Details' and the aother 'Add Details'. so i then used
the switchboard manager to link the appropraite forms to the right bottuns on
the switchboard.

Now, when i use the edit link, unless my record has ALL it's fields filled
in, it wont show anything. it comes up blank when i use the ID prompt. but
the records that DO have all info filled in, will show. BUT, then the combo
boxes are not working. they will show the list, but wont let me select
anything. I have checked the forms 'Allow Edits/Deletions/etc' and they are
all set to 'yes'. then the control's 'Enabled' is 'yes' and 'Locked' is 'No'.

where am i going wrong? i am using a query as my forms record source to
prompt me for the employee ID number and surname. if that helps.

Thank you all in advance
Kind Regards
Rigby
 
The form may be based on a query which is readonly or not updateable.

Check the query - by running the query in the "Queries" tab in database
window - can you update any data there?

Regards,

Naresh Nichani
Microsoft Access MVP
 
Hi Naresh

I tried updating the data like you said. Nothing. It still wont allow me to
do so in the queries tab. how can i change it to updateable?
How can i create it so that when i open my form in add mode from the
switchboard, it will come up with no records listed. at the moment, it comes
up with the last record added. i dont want them to be able to see any
previous records when opening the form in add mode, only in edit mode.??

Thank you for you interest.
Rigby
 
You indicated that you are calling the form from the switchboard.

Go back and double check in the switchboard editor that when you open
the form from that button it is in "Add Mode" as opposed to "Edit Mode".
 
Back
Top