One record at a time

[iceruam]

I am looking for a way to pull up one record at a time from access/mssql. Currently whenever a user opens the default form every record is loaded, this may take 4-7 minutes to open. I have a search field at the top which how we navigate, we never, repeat...never go from one record to the next, we always type in the client number in the search field. What I would like to do is by using that search field access the clients record with all subforms but only one at a time. I hope I made sense....
Thanks

[June7]

Have an unbound 'menu' form as default. This form can have combo or text boxes for filter criteria. Have buttons to open other forms/reports using WHERE CONDITION for filtering to the one record:

DoCmd.OpenForm "formname", , , "ID=" & Me.tbxID

[iceruam]

i will give this a go

Have an unbound 'menu' form as default. This form can have combo or text boxes for filter criteria. Have buttons to open other forms/reports using WHERE CONDITION for filtering to the one record:

DoCmd.OpenForm "formname", , , "ID=" & Me.tbxID

Kind of funny but I just found this on here too, essentially what I am wanting https://www.accessforums.net/forms/h...ata-22896.html