Using Combo Box to go to a particular record

[ivijayan]

HI!

I have a form linked to a table which i use for entering and viewing data. It has a tab control in it with the first tab having the main table and other tabs having linked tables as subforms.

I want to create a combo box control which i intend to populate with values in a particular field of main table say ID field of [Main Table].
I want it to run in such a way that as select a particular value in the combo box it should show the corresponding record in the tabcontrol.

I am not very good at programming so would be grateful if it can be explained in detail.

Thanks & regards

Vijayan

[cyberdwarf]

Hi Vijayan
You can place your code in the AfterUpdate event of your combobox
It would look something like:-

Me.MainID = Me.MyCombobox
Me.refresh

HTH
Steve

[ivijayan]

Thanks for the guidance Steve.

I did exactly as told. There were no errors. But it just did not connect properly with the table as the corresponding record was not shown.

The Code i entered was :-

Me.[Last Name] = Me.Combo35
Me.Refresh

There was another strange happening. In the [Last Name] field the value changed automatically to the Code no field of the particular record.

Help please.

Rgds

Vijayan

[Rabbit]

You can use DoCmd.FindRecord. The help files will provide you with what you need for the parameters.

[ivijayan]

i tried it as well.
But that is also not working.

I used the following code:-

Private Sub Combo35_AfterUpdate()
Dim comboValue As Variant
comboValue = Me.Combo35.Value
DoCmd.FindRecord comboValue, acEntire, False, acSearchAll, acAll, True
Me.Refresh
End Sub

It is not working and gives an error.

I am a novice at VBA so shall be grateful if you could explain.

Regards

VIjayan

[ivijayan]

i used the following as well

Private Sub Combo35_AfterUpdate()
Dim comboValue As Variant
comboValue = Me.Combo35.Value
DoCmd.FindRecord comboValue, acEntire, False, acSearchAll, acAll, True
Me.Refresh
End Sub
 

but same result - error.
pls help.

[missinglinq]

Why not simply use the Combo box wizard? I jsut posted this two minutes ago for another poster:

Create a form using the table/query as the Record Source.

Goto the Field List and drag the fields you want retrieved onto the form

Place a combo box on the form

Select "Find a record on my form based on the value I've selected..."

Next

Select the appropriate identifying field

Next

Size the Combo box column

Next

Name the combo box

Finish

Now the user can use the dropdown arrow of the combo box to retrieve the dtata or simply start typing the identifying data in and the combo box will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriaate data should be retrieved.

Good Luck!

[ivijayan]

hi.

Thanks forthe help.

It worked.

However I want some customisation:-

1. I make my selection based on 2 fields [Last name] & [First Name]. But after selection only the first field is showm in the combo box. Can't it be tweaked to show both the fields.

2. Lets suppose I want the Combo box to take values from some other table or Query.
For instance, there are some records which are "dead" records and would not be updated ever again. No point in showing the corresponding [Last Name] & [First name] values for such records. So i have a query which does not include these "dead" records and has only live records. I want my combo box to list values from this query containing live records but show detals from my original table so that they can be updated. How do i manage this?

Shall be grateful for your help.

[ivijayan]

PLease help.

Vijayan

[ivijayan]

HI Friends

Nedd your help

PLease

Regards

[ivijayan]

HI

Please help me

Do not be so inconsiderate.

Regards