Search Record In A Subform

[Gasman]

The code you need to see the value is

Private Sub Command38_Click()
MsgBox "Your Subformvalue is :" & Me.cntPassDetails.Form.Passenger_Name
End Sub

I have not used macroes, except for batch processes, and looking at this, unlikely to.

I suggest you start here.

http://allenbrowne.com/tips.html

There is a search form there and I used that method for one of my DBs.

I do not have the experience to write this for you.

There is a SearchForRecord macro, but that appears to only work on tables, forms, reports and queries. When I tried with your Client_Details form, it complained it was not open, so obviously could not see it within the subform control.

You need to bite the bullet and learn VBA else find a site that uses macroes extensively, as hardly anyone here uses them as far as I know.

Also you will need to use the main form control sect as that is what you are trying to find, after seeing your form.

 

[Gasman]

https://www.youtube.com/watch?v=iJcB5WkEmb4

 

[Gasman]

Done it !

See pic

The key is I had to go to the subform control first, not the actual control.

However, if I click into Relation in the subform it will find in that, so not ideal.:banghead:

 

[Gasman]

Here is another way, changing the record source.

https://www.youtube.com/watch?v=N0X8Hg-Sm6A

However ignore the Requery statement, as changing the record source does it automatically. You'd only be doing it twice.

You could start checking Youtube as well as a picture is worth a thousand words.

HTH

 

[vagues0ul]

Done it !

See pic

The key is I had to go to the subform control first, not the actual control.

However, if I click into Relation in the subform it will find in that, so not ideal.:banghead:

worked like a charm your comment is a life save .. had to ammed a bit but it worked. THanks a million <3
attaching the ammended macro pic

 

[vagues0ul]

thanks to all senior membes who also helped me. i have also learned about using the vb in code and found two vb codes to make app better.. Thanks you ALL

 

[Gasman]

You need Find First set to No, else you will never find the next record with the same criteria?

 

[vagues0ul]

You need Find First set to No, else you will never find the next record with the same criteria?

the records only contain single non duplicate value. so it will work for me . thanks for suggestion.