SendKeys Macro won't work with Dialog box?

[gwendon]

I'm trying to use a SendKey {F6} to place data into a dialog box. I read the following in Access Help:
"Because the dialog box suspends the macro, you must put the SendKey action before the action that causes the dialog box to open."
The question I have is where and how do I place SendKey action before the action that causes the dialog box to open?

 

[BillPower]

Have you considered using VBA.

Put the following in the on click event of a button on a form to see how it works.

Dim Retval
SendKeys "Tek-Tips" 'Try this first
'SendKeys "{F6}" 'Try this next (delete the quote from this line, add a quote to the one above
Retval = InputBox("Test Sendkeys", "Test", Default) 'open a dialog box

You could try this for your earlier Parameters Query thread as well.

If you want to stick to macro programming, can you post the code you're using in your macro.