Finding a record by autonumber in form to edit

[sunnyday]

Hi,
I have a Navigation form inside which resides the Navigation subform and another subform in the Navigationsubform.Now if one wants to edit data by going into their specific ID no which is an auto number how do I do it using a Macro.I have tried using the combo box to search out the ID no,but the subform inside the Navigation form does not appear to edit. The reason being Navigation subform Recordsource is a table which is linked to the table for the subform inside Navigation subform
I have tried using code but the nos are not coming up to select
Private Sub cboMtSearch_Click() where cboMtSearch is the control for combo box select

Dim MyMasterID As Integer
MyMasterID "Select * from Master where ([MasterID]=" & Me.cboMtSearch & ")"
Me.NavigationForm.NavigationSubform.Form.RecordSou rce = MyMasterID
Me.NavigationForm.NavigationSubform.Form.Requery


End Sub

[pbaldy]

Based on what you're doing, the variable would need to be declared as String.

[sunnyday]

I have tried Dim MyMasterID as string , still no numbers show up

[pbaldy]

And

MyMasterID = "SELECT...

[sunnyday]

I solved it by using a combo box using find a record based on values on this form and place dit in the form header of the Navigationsubform and it seems to work

[sunnyday]

The new problem is the combo box works in my navigation subform but does not work on other desktops if i try to craete the same combo box following the same procedure as I did on mine. Is it because the users are not admins of the database and are just users? I generally send the db file from my computer via email and they save it to their desktops. As I said the db is a split one. Back end in corporate network drive and front ends in user stations.

[pbaldy]

The code above should work for any user, once fixed. What code did you end up with?

[sunnyday]

Well I used the combo box functionality on the form Header where we can select the values based on values or records available on that form. And the auto nos showed up to select the relevant auto number to find the particular record to edit.
The macro runs for After Update event as
Object Type
Object Name
Record First
Where Condition =="[autono]=" & Str(Nz([Screen].[ActiveControl],0))