By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,400 Members | 1,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,400 IT Pros & Developers. It's quick & easy.

sub form behaviour

P: 5
Hi
I am new to access so I apologise in advance for asking 'rookie' questions.

I have a main form that the user selects a project from a combo box, I then display the information for that project on a sub form. To select the infromation for the project I have a query in the recordSource of the subform that uses the cboproject.value in the selection criteria.This seems to work OK.

My problem is that I cannot edit any of the fields on the subform. All the fields are text boxes with the enable attribute set to 'yes' and the locked attribute set to 'no'.

Any ideas?
Sep 25 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Is your recordset on which is based you subform is editible?

Can u enter some information and then appears the error that u can't add

or simply u can't introduce nothing?

:)
Sep 25 '06 #2

P: 5
Is your recordset on which is based you subform is editible?

Can u enter some information and then appears the error that u can't add

or simply u can't introduce nothing?

:)
I can see all the fields in the sub form but cannot edit any of the data - I don't get any error messages - it is as if the fields are not enabled. I suspect the probelm is due to the fact that I am using a query to populate the subform.
Sep 25 '06 #3

PEB
Expert 100+
P: 1,418
PEB
So open your query and try to edit a field if u can't so u need to change your query!

:)
Sep 25 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.