Automating a form

[Jana]

I am making a form for a contactor to walk around a
building and make punchlist items. I have the form
situated so that it drills down to particular items based
on information in previous fields. For example, they can
pick a certain building and only room numbers from that
building appear in the drill down for rooms. I would like
to format the form so that when they click on a command
button it brings up the information from the last entry.
I don't want to duplicate the entire record just certain
fields. I know that you can use ctrl+' to do this per
field. Because people will be doing this in the field,
the less use of the keyboard and more use of the mouse,
would be the best scenario. Is there any way to put this
function in a command button.

Any help would be greatly appreciated.

Jana

 

[Bob]

You might want to try "SendKeys" within a macro and assign
the macro to the command button.