How to Question VBA

[Lavenderchan]

Hi I have a combo box set after up date to auto fill parts of a new record I have it set up like this
Row Source: SELECT [Property Name],[REMS Number],[FHA Number], [Contract Number], [Project Manager]
FROM [q_Open Items] ORDER BY [Property Name];
Column Count: 5
Bound Column: 1
Column Widths: 2,0,0,0,0
Me.REMS_Number = Me.Combo32.Column(1)
Me.fha_number = Me.Combo32.Column(2)
Me.contract_number = Me.Combo32.Column(3)
Me.Project_Manager = Me.Combo32.Column(4)

But I need to set the FHA Number in a combo box option to and also auto fill after update. I need the to search options but when I tried to set up the FHA Number to run the same way the information pulled into the wrong fields.
Is there an easier way or am I on the wrong track.
Thanks,
Keri

 

[Remou]

Will you please explain again, I am not getting what you want. Do you want a different combobox for FHA numbers, or is the existing combobox not working for you? What are these search options you speak of?

 

[pcast01]

I think I know what you mean...

You have an AfterUpdate code that sets those values in hte text boxes after you select a value in the combo box.

Now you are saying that whatever value is put into the FHA text box will determine what is put in other fields. Is that correct?

CHAOS, PANIC, & DISORDER - my work here is done.

 

[Lavenderchan]

Yes, I figured out that I had the data colums mix up in the sql statement its working fine now. Thanks for taking the time to read my post and answering my questions.

Keri

 

[pcast01]

Sure no problem...

Good Luck!

CHAOS, PANIC, & DISORDER - my work here is done.