If this returns a value of true....

MsgBox Me.mysubformname_subform.Form.RecordSelectors

then why does this not error out but the recordselectors are still visible ??


Me.mysubformname_subform.Form.RecordSelectors = False


I cannot set the recordselectors off on the subform before putting it on the mainform as there is some tricky stuff going on preventing it.

Hi Bob,

If you're just trying to turn the recordselectors off on a sub-form that is within the main form then your code is correct. I don't even know of a setting that would prevent that. Are you sure that you do not have any other code running that is causing it to revert back to display the record selectors?

nope. I think it has something to do with the subform being an unbound form and the query using values from the mainform as the parameter query. It isnt a show stopper. Now I am trying to click on field on the subform and do something.

trials and tribulations for a tuesday

suggestion....

Instead of having the Sub Form formatted as a Form, have it as a Datasheet, therefore you will not see the record selector.

RAZMaddaz

if i do that would that make it easier for the user to click on a field and then drill down from there ?

scenario:

the main form is based on a crosstab query (thanks RAZ). When the user selects a row and then a listbox and then a command button, a query is run with those values as the parameters and then uses that query as the recordsource for the subform. Works great. Now, lets say there are 5 items in the subform, I want to select record 2 and get the value from 2 different columns and use them in a query. when they close that query they would be back at the subform and when they choose the next record (my not be the next sequence number) they could repeat the process.

Bob,

When something like this requires a User to choose a bunch of criteria from various Sub Forms, I instead create a simple unbound Form, with a bunch a Combo Boxes , where the User can choose one or all of the Combo Boxes and the results show on a Report.

Why are you trying to create something so difficult, when it could be much easier?

RAZ

there is only one main form and one subform

to this point it works just fine.

one the subform there is a column for projecttype and project. I can click once and get the values i am looking for to be returned in a message box which means I could pass them to another query. However, now that I am in the subform each additional click has no effect on the message box. The only choices I have are subformenter and subformexit.

If I click back on the mainform and then click back in the subform I can choose another item.


In this scenario, I do not feel cascading combo boxes will work for the user and what we are trying to do.

Then can you add a button on the Sub Form somewhere, so that the data on the Sub Form gets refreshed? Or maybe on the After Update of the Main Form, for the Data of the Sub Form to get Refreshed?

i can try that. i was trying to just set focus to a control on the mainform and then just click back into the subform but that techinique failed.

trial and error it is