Textbox=[combobox].column(#)

[bodvoc]

Hi all

Can anyone help me, i am using a textbox to store personal details that are looked up by a combo box (running of a query)i.e.

Textbox=[combobox].column(#)

# being the number of the column wanted.

But, if I have two or more people living at the same address, though it shows the right info in the form i.e. person 3, it puts person 1 details in the supporting table??

I have a primary key set on an auto number, is there any way of using this to lock the info to the right person? Did it with dlookup but thats to slow over our network!!

Thanks

Bodvoc

 

[Rich]

The PK is normally the Bound column, why are you referring to a column number?

 

[bodvoc]

Well, the PK is bound, but the query also looks up, name, address#1, address#2, town, county, postcode and phone number.

So if you use colum(1) you get name in the text box, if you use colum(2) you get address#1 in the text box, etc. etc. Column(0) is the PK.

The thing is, these are Doctors surgery addresses, and it seams to pull up the right info in the form, but puts the first record in the background table?

i.e. Doctor C details in the forms, but Doctor A details in the table?

Bodvoc

 

[Rich]

The query criteria should refer to the PK, ie the bound column

 

[bodvoc]

Think I cracked it, I found a bit of inherited code that was causing the record to screww up. Thanks for your help

Bodvoc