VBA DoCmd.FindRecord ?

[Turnip12]

I'm trying to create a button on the start up form that allows the user to jump to a specific record on a certain form. I've found sloppy solutions, but I'd like the code on this one to look nice so I'm trying to figure out the correct way to go about doing this. My most recent attempt consists of a button on the start up page that opens up a form called frmFind, and a form called frmBody. On frmFind, there is a text box and a button. The text box sets the value to a global variable, and then searches for the first instance of that value, a string, in frmBody, and opens that record. (any of this making sense so far? I'm terrible at trying to explain my coding) My code for the button is as follows:
1 Screen.PreviousControl.SetFocus
2 gSearch = txtTitle.Text
3 Forms!frmBody!txtTitle.SetFocus
4 DoCmd.FindRecord gSearch, , , , , acAll
Line 1 to send focus back to the text box so line 2 will work, line 3 to switch focus to frmBody, the form I want the record to open up in, and line 4 the actual FindRecord action. The error message I keep getting is : "A macro set to one of the current field's properties failed because of an error in a FindRecord action argument." Any help would be appreciated, especially if I'm going about this all wrong If there's a better approach to take, I'm open to them, but I'd like it to be extremely simple (for the end user) and I'd rather not use the built in find function. Thanks.

[qball]

I'm likely no VBA help here, but maybe process, then you implement.

Quote:

I'm trying to create a button on the start up form that allows the user to jump to a specific record on a certain form.

do you mean a specific DB record/row and specific form? forms don't really have records, they show records that exist somewhere, or not (could be totally made up).

anyway, this should be no problem, kinda sorta...

to do this correctly, you need to find out what record on what form the user desires. This could be non-trivial, as thousands of forms may exists that access millions of DB rows. As it seems you are using a GUI (VBA) in a client/server enviroment, this should be a bit easier.

looks like you have "Jump to Record" button on start form that pops up dialog for user to enter text, right?

Now, do the users know what form and record they want to see? Or just what record?

Pop up a dialog that contains:

list of forms, user choose form.
text box, user which record to find.

This dialog can work a few ways.

1. user choose form AND enter text.
2. user can choose form and optionally enter text.

1. will take this info, open/make/create form, search for record.

if (found)
{
//woohoo!
//show form and highlight/focus on proper record
} else
{
//boohoo!
//dialog box, "user no record found, here is requested form"
//show form and highlight/focus on first record
}

2. will:
//show form and highlight/focus on first record

either way, should be obvious that only enable 'OK'/'Show me the form/record' button only becomes enabled when user has chosen appropriate info.