Auto fill Drop down box for current records

[neoroses]

Hi all



So ill try and get this down in a way that does not just make sense to me!

Ok i have a database

two tables: Addresses, Instructions
One form_one subform: User form

The user form contains set of instructions for each company that we take care off, the sub-form has all of the addresses for the company, these come from the "Address" table, the two are linked via a field called "companyID" so the subform only displays the addresses for the current company being viewed on the form.

The problem is, on the subform there is a dropdown box called "administrator" and this is used to select the person who is looking after the company. Some of the companies have hundreds of addresses, so when i click the next record button on the subform I have to fill in the administrator again for every address for the same company. Is there a way using vba or a simple function to auto update all of the "administrator" dropdown boxes for that company based on the administrator I select for the first address.

Cheers guys n gals

ps access 2010

[Missinglinq]

You can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

Just replace YourControlName with the actual name of your control for the administrator's name.

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

Linq ;0)>

[neoroses]

Thank dude, this did not work, is this because the values in my dropdown box were typed? should i have the values stored in another table?

Thanks again man i really appreciate the help

[neoroses]

this is what i put:

my drop downbox is call administrator



Private Sub Administrator_AfterUpdate()
Me.Administrator.DefaultValue = """" & Me.Administrator.Value & """"
End Sub

is that correct?

[ssanfu]

Looks right....

I just tested Linq's code and it worked for me. (although I don't type the ".Value" since it is the default property - personal preference)
You have to type in the administrator name once (or whenever the name changes).

The control "Administrator" is bound to a text field in the record source?

You added the code to the sub-form module? Not the main form module? (Just asking since I cannot see your dB)