get name where number =

[revnice]

I've got a combo box in a form that lets me choose the Customer.

Once I choose the customer, I want the other two fields to auto-populate from the same table (see pic).



trb1560 actually did this for me in my initial post but when I click (...) to see what he did, Access crashes.

Presumably, I need to add the correct criteria to the query? I can't have 'where number = 0003' i.e. a specific number because the number won't be known until the combo box looks it up.

Can anyone tell me what that criteria should be - and where to put it

Thanks - rev



Thanks - rev

[RuralGuy]

What do you have as the RecordSource of your form?

[revnice]

CUS_ID for the CUS_ID field - and it selects the ID and Name and shows me both in the combo box. That works fine, but it doesn't populate the other fields.

That's what I need to know.

[RuralGuy]

Try using the ComboBox wizard to create another ComboBox and this time select #3 option.

[revnice]

I'm off to try it, thanks.

[revnice]

If by 'third option' you meant:

*Queries
*Tables
*Both (3)

I checked Both but it made no difference on its own. Maybe there's something else I have to do once that's checked?

[RuralGuy]

When you create a ComboBox with the wizard the wizard starts off by asking you what you want your ComboBox to do. Select the 3rd option.

[revnice]

I selected the third option and now CUS_NUM appears in the NAME1 field. See pics.

I can't choose CUS_ID as the record source for CUS_ID because it doesn't appear in the list! What's going on?

Can somebody spell it out for me, I've been on this for days!

Thanks - rev

[RuralGuy]

The ComboBox cannot be bound for it to work properly.

[revnice]

It's Unbound and still doesn't work properly.

Why isn't CUS_ID available as the RecordSource? I was getting it yesterday but I don't remember doing anything different.

[RuralGuy]

Your ComboBox should *not* have a control source but the other two TextBoxes should have a control source. Do they?

[revnice]

Yes they do, they contain the correct column for the source of the data.

[RuralGuy]

They need to point to a field in the RecordSource of the form. Use the cbo in the property to select the correct field.

[revnice]

See pic3 above. Is that where you mean?

If that's where you specify the field, it's already there Name1 and Name2 for each form field respectively.

[RuralGuy]

Nope! That's in the property sheet of the ComboBox and not done properly I might add. You need to look at the property sheets of both TextBoxes.