Solved how to Find a record on another form (1 Viewer)

[smig]

Hello

I need to find a specific record on another open form.
I want to select the "RecordName", based on the "RecordID"
How can I do that ?

Thanks

 

[Minty]

You could use a recordset clone of the forms recordset, then a find first on that.

 

[arnelgp]

why do you need to find it in the form?
you can find it in the table/query using Dlookup().

 

[smig]

why do you need to find it in the form?
you can find it in the table/query using Dlookup().

I requery the form to show some changes made.
I need to go back to the record I was in

 

[theDBguy]

I requery the form to show some changes made.
I need to go back to the record I was in

Hi. Just curious, rather than use this,

Me.Requery

try it this way,

Me.Recordset.Requery

 

[smig]

I'll try to explain the situation better

I have a form with two SubForms
The top one show a list of records and the bottom one show some data for the selected record on top.

After editing data in the Bottom one I need to requery the top one to reflect some changes made.
Now I need to go back to the record I edited

 

[Minty]

Use recordset method and a bookmark.

 

[smig]

Hi. Just curious, rather than use this,

Me.Requery

try it this way,

Me.Recordset.Requery

Thanks
This do the job

 

[theDBguy]

Thanks
This do the job

Hi. Glad to hear that. Good luck with your project.

 

[Pat Hartman]

Just FYI,
Forms don't store data. Tables store data. If you're looking for data, look in a table, NOT in a form.

 

[smig]

Just FYI,
Forms don't store data. Tables store data. If you're looking for data, look in a table, NOT in a form.

I know