GoToRecord Macro??? Form to point to concerned record

[May]

Hi,
I have a form with a ComboBox that shows all records of
one field of a table, And a host of other text boxes. The
user picks a value from the dropdown combo box, then fills
in other values in all the text boxes, thus populating
each record of that table.
Problem: The form seems to be in the first record mode
even though user chooses 2nd, 3rd or nth record, unless he
uses the record number box at the bottom.
How can I make the form point to the record number of the
value that is chosen in the combobox? If it is GoToRecord
macro then, the macro should point to which event? And
what should ObjectType, ObjectName, Record and Offset
point to?
Appreciate help. Thanks in advance.

 

[Howard Brody]

If the values in the ComboBox are unique (not duplicated)
try the ApplyFilter action in a macro. There are only two
items for this action:

FilterName - you can leave this blank
WhereCondition - "[FieldName] = [Forms]![frmFormName]!
[ComboBox]"

Hope this helps!

Howard Brody

 

[May]

Thanks, I really appreciate your help but it did not seem
to work. Values in combo box are unique (is primary key).
12 boxes need data input by user to populate the
corresponding records.
The 12 text boxes are still showing the first record. I am
still forced to use the Record Number box to navigate
through records.
Choosing a value in record # 2 for eg. is not forcing the
rest of the objects and textboxes to point to record # 2
of the table.
I will really appreciate any further help. Thanks

 

[Doug]

Have you tried doing a forms refresh to update the form
itself?

Doug

 

[John Vinson]

Thanks, I really appreciate your help but it did not seem
to work. Values in combo box are unique (is primary key).
12 boxes need data input by user to populate the
corresponding records.
The 12 text boxes are still showing the first record. I am
still forced to use the Record Number box to navigate
through records.
Choosing a value in record # 2 for eg. is not forcing the
rest of the objects and textboxes to point to record # 2
of the table.
I will really appreciate any further help. Thanks

May, it really helps if you reply in the thread where you were
conversing before. I have no idea what prior discussion you have had,
nor what the exact problem might be - I'd have to go to Google and
search for your name to find it!

What is the Recordsource property for your form? What code (if any) do
you have on the AfterUpdate event of the combo box? What is the
Control Source of the combo box?

 

[May]

Yes I tried. Also tried putting the macro in the form
events, detail, combo box. Somehow the connection between
the combo box and the rest of the text boxes is not being
established.
The mystery is killing me. Appreciate any help. Thanks