Two Forms One Combobox

[rhubarb]

I have a single form with a combobox (which does a distinct select lookup from a tickets table). I also have some other fields on that same form from a different table (the customers table). So now when a user drops down the box or starts typing a job address it appears on the same record. Instead of this I'd like it so that when the value of this combobox changes all the corresponding details of the table will match that value. That way when someone enters the address the other details, if in the table, will appear. Is this possible?

[ranman256]

Sounds like you have it BOUND to the record. Make sure the datasource of the combo is UNBOUND. (not attached to the record)

I'm unsure of what you want after user picks it.

[rhubarb]

Okay, I'll take a look at that datasource. Thanks.

Once the user selects a value from the combobox, the other fields on the form should populate with their corresponding information.

[rhubarb]

I think this may be what I was looking for:
http://access.mvps.org/access/forms/frm0005.htm

[ranman256]

I think you want to FILTER the records based on the cbo pick.

in the Cbobox after_update event

me.filter = "[myField]='" & cbobox & "'"
me.filteron = true