Setting Text Boxes on Form to Initial Blank Value Until Selection is Made?

[McArthurGDM]

Hi,

I have a form that is bound to a table. On this form is a dropdown to select a specific record. I want every other control linked to this table to show as blank until an initial selection is made in the drop down. How do I do this?

Thanks,

[nick404]

In the properties for the other fields click on the data tab. Have Row Source Type set to "table/query" and click the three dots on the field above (Row Source). Will take you to a query builder.
Use an SQL like this one, with your table, field, form, and combo box names

SELECT tblName.field1FROM tblName
WHERE (((tblName.field2)=[Forms]![formName].[comboboxName]))
GROUP BY tblName.field1;

Field 2 is the field that populates the main combo box. Field 1 is the field that you want contingent on the combo box (i.e. the one that you are editing the property for).
Hope this helps...

[CJ_London]

couple of options

1. change the form dataentry property to true
2. in your combo after update event, put code to change it to false - and probably the code in 2 below

or

1. put in the form filter property [ID]=0 and save the form - substitute the name of your autonumber field for ID. Alternatively put this code in the form open event

me.filter="[ID]=0"
me.filteron=true

2. in the combo afterupdate event put

me.filter="[ID]=" & me.comboname
me.filteron=true