Cannot enter data in fields on my form...

[Newbie2012]

Cannot enter data in fields on my form...

I'm not sure how to explain because I'm a newbie...but any prompting will be appreciated to get some help.

I have quite a few fields which are lookups to other tables and then there are a few queries as well

I can't change or edit any fields on this form. Do I need to create a master query with all the relevant fields and use it as the Forms main Record Source?

Thanks in advance.

 

[pr2-eugin]

I am not sure if I get this right.. From my understanding, you have a unbound form which places the values.. by using queries in their datasource property.. But what you want is to change the values and store it in a table.. If that is correct.. what you need to do is.. properly structure a table with 'relationships' and good 'normalisation' rules.. then make the form bound to the table.. This will allow you to make changes to the table through the form..

 

[vbaInet]

Not unless you've mistakenly set the Allow Edits and Allow Additions properties to False? Or the Recordsource Type property to Snapshot. These settings will make your form read-only.

If that's not the problem, see here for other reasons:

http://allenbrowne.com/ser-61.html

 

[Newbie2012]

Ok well I will try and check what you're both saying here...

I didn't get no email notification for these replies either so I'm sorry about responding late. Thanks...I'll be back...

 

[Newbie2012]

Ok well I will try and check what you're both saying here...

I didn't get no email notification for these replies either so I'm sorry about responding late. Thanks...I'll be back...

Allow Edits was set to 'no'...after changing it to 'yes', I can now make my changes. Thank you.

 

[vbaInet]

Lovely job!