How to autofill form fields in vb with access db

[asadameer]

How do i select company from combo box so other fields should fill automatically from its table.

I have following fields

Company name
Company address
company Phone Number

[debasisdas]

for that you need to frame the query dynamically by passing the selected value from combo box at run time.

Please post the code that you are working on.

[asadameer]

thanks for you reply
bro i am working on msaccess 2007 basically i want to fill company address and company phone number automatically when i select company name

[asadameer]

can anyone reply asap please i am stuk here plzzzzzz

[smartchap]

In the access database search for the Company Name selected in combobox (put this code in ComboBox_Click event) from first record to Last record. As soon as the Company Name is found, fill other textboxes (Address 7 Phone No.) with other fields' data in that particular record.