subfrm

[jarheadjim]

My switchboard has a subform on it that doesn't allow me to change the data (in this case check boxes). If I open the subform alone it allows me to, only when viewing it through the switchboard is it locked. Where do I change the property to allow updates?

 

[Dgavilanes]

Hi, Check your linkmaster links and your child subform links.
the reason it works by itself is because is not link to anything, but when you open thru the switchboard it shows the parent as well as the subform. correct!!!!
Dennis

 

[jarheadjim]

no go

There isn't anything on my switchboard to link to the subfrm. I want to be able to update my subform and have it change the table that it's based on.

 

[afloyd]

Could you provide a little more information about the subform on your switchboard. I'm not sure what you mean. I don't if I can help, but a little more info would be useful.

I would think that from the switchboard you would go to a parent form that has a subform. Is that what you are talking about?

- AL

 

[jarheadjim]

to clear things up

my main switchboard has a subform on it that shows me what crew (days or nights) all of the Marines that work for me are on. I would like to be able to update their info through the subform rather than opening up a second form that displays just that one persons information. It is not linked to anything, I just made it for a quick refrence to the user and wanted them to be able to change it "on the fly" rather than navigating switchboards. Clear as mud(I'm SOOOOOOO bad at explaining these things)?

 

[afloyd]

I can't say that I have an answer for you. However, something to consider when updating a group of records is to use an update query. If the same information is being changed in multiple records you can write your SQL update to use the checked fields in the WHERE clause.

UPDATE <field>
TO <data>
WHERE (forms)!(form_name)!(field_name) = TRUE (this would be the check box)

this may not be the exact syntax, but I think it's pretty close.

 

[jarheadjim]

i actually want to affect each record individually, the only items changing will be checking/unchecking boxes. but thanks for the help.