Form/Combo Box Query

[rcough]

I have an sheet with information like the one below. I have a combo box set up with the info on a form. I can't get the form to display the correct information from the sheet when I change the combo box value to 2000 it is staying at the default 1000 value.

Example Sheet Below

Data	Value1	Value 2	Value 3	Value 4
1000	0.5	0.75	1	1.25
2000	0.6	0.66	0.72	0.78
3000	0.7	0.8	0.9	1

So what i need to show is when i load up the combo box with the Data Value the Value 1, Value 2 ect all change to the correct value.

Hope that's correct, difficult to explain. I have done it before a long time ago and can't remember and can't seem to find a video on how to do it again.

[Welshgasman]

Requery your data source.

[rcough]

I sadly don't think its that, it looks like i have missed a step somewhere. As i have refreshed and nothing has changed.

[Welshgasman]

So attach your DB and instructions of how to replicate.

[mike60smart]

Hi
Try deleting the Combobox and create a New One.

Make sure you select the 3rd option - To find a record etc....

[rcough]

Sadly the real one i am using is on a secret system so i can't share it.

[rcough]

I have tried that, still nothing, but not sure when i select 3rd option to find a record, where is that?

[mike60smart]

Hi
When you create the Combobox the first window that pops up should look like the attached which shows the 3rd Option.

This would happen if you are basing the Form on a Table.

If you are basing the Form on a Query then this 3rd Option will not be available.

[Welshgasman]

I have tried that, still nothing, but not sure when i select 3rd option to find a record, where is that?

I think Mike might be thinking of the command button wizard?

[Welshgasman]

Looking back on your original post, I do not think your DB is normalised and that might be your issue?

If you have 1 in your combo are you expecting to see records 1 & 3 ?

[rcough]

That might be it as i don't see that option when i create the combo box, and i seem to remember that now from last time, how do i get that to appear. Would PM you if i knew how

[mike60smart]

Hi

If you click on my name and then select Private Message

[Micron]

In some other forums inviting someone to pm you to solve a thread is against the rules. If it's not here, it probably should be.

[Welshgasman]

In some other forums inviting someone to pm you to solve a thread is against the rules. If it's not here, it probably should be.

Yes, noone else on a site benefits from any assistance given by PM.

[rcough]

Thanks all for your help i have managed to sort it out now.