Clear all text boxes on a subform [Datasheet].

[Robeen]

Hi,

I am using this code:

Dim ctlTextBox As Control
For Each ctlTextBox In Me.Controls
    If TypeName(ctlTextBox) = "TextBox" Then
        ctlTextBox.Value = ""
    End If
 Next ctlTextBox

to clear all text boxes on a Main Form.

When I try the same code in the Form Load of the sub form - it says I can't assign a value to this object.

I just want the Main Form and Sub Form textboxes to be empty when they both Load up.
There is a selection combo box that will populate the main form and the sub form [Master-Detail] once a selection is made.

Right now the main form has all empty textboxes but the subform datasheet is showing detail irrelevant records belonging to another master record and I want no data till a cmb box selection is made.



Thanks!!

Thanks!!

[orange]

Then, I think you have a linkage problem or corruption.
How are the Form/subform related? Typically Linkfields

[Robeen]

Sorry, I didn't explain comprehensively.

The Form & sub form are working just fine in relation to each other.
The records showing in the Detail Form to start with are the ones pertaining to the very first Master record that is loaded by default [but I subsequently "" that data out in Form Load].

When the selection is made from the ComboBox - everything falls into place & the master-detail relationship works perfectly and the users will see exactly what they asked for.

The 'problem' is that Users will be going in to select a particular set of Master records - each of which could have one or more detail records - and when the forms FIRST open up - they will be looking at some other data.
I just want them to start with a clean slate - blanked out Master & Detail Forms.

My Band-Aid fix for now is to hide the Detail Form to begin with - and only show it after I have re queried the Master form with the selection criteria.

My question here is how to blank out fields in the sub[datasheet] form... if possible. I would really like to know.

Another thought I had was to set the initial record source of the Detail Form to a query that will always return no data . . . ??

Thanks!

[June7]

I am confused. First you say subform shows records not related to main form then you say the links work properly.

If links work, how can subform show data not related to the current main form record?

Is the selection combobox UNBOUND? Must be if used to input filter criteria.

Why would you not want subform to show records - why should it be blank if the main form shows existing record and there are related records?

Is the subform in datasheet view?

[ssanfu]

This is normal....
"When you open a form containing a subform, the subform and its records are loaded before the main form".

See
Order of events for database objects
http://office.microsoft.com/en-za/ac...005186761.aspx

Click on Order of events for forms and subforms
Look for Working with subforms at the bottom of the page.


How to fix/change this.....?????

[Robeen]

I think I made it confusing - sorry.
__________________________________________________ __________________________________

Bottom line: How do I 'Blank out' everything that shows up in the Sub Form [Datasheet] when the Form Loads? That is my question.

I want to start with a blank Main Form and a blank Sub Form.
I have 'blanked out' the Main Form text boxes.
I can't blank out the sub [datasheet] form... [so I am currently making it not visible].
I need help blanking out the sub form in the same way that I blanked out the Main form.

The goal is:
The Form loads - with the sub form - but both of them show no data.
The User makes a selection from the combo box - my code changes the Recordsource for the Main Form & makes the sub form visible - and now the Main and Sub forms both show what the User needs to see.

__________________________________________________ _________________________________

The Combo Box uses its Row Source to get a set of available Values to select from.
When a value is selected, I have a SQL statement that I plug the selection text into and then I use the SQL and a Requery statement to change the Recordsource of the Main Form.
Then [currently] I am making the sub form visible ... and it has all the rows pertaining to the record on the Main Form displayed in datasheet view.
The Master and Detail forms are working as Access intends them to.
The Combo Box is working correctly.
__________________________________________________ _________________________________

[June7]

Never done this but some possibilities:

1. open main form to new record row.

2. open main form filtered to a dummy id (0)

3. subform RecordSource is blank, set it after selection from combobox

4. unbound forms