If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
opening a bound form on specific entry
hi all, i have a form bound to a table. from another form, is it possible to
open this form on a specific record? from a command button on my form bound to tbl:repairs i open my form bound to tbl:sitereports and default to the site report for that repair job (linked by an id field common to both tables) i guess it involves handing a variable to the sitereport form and i cant find how one can do that. (i'm not very familiar with access) any help appreciated, vauneen |
#2
|
|||
|
|||
opening a bound form on specific entry
"vauneen" wrote in message ... hi all, i have a form bound to a table. from another form, is it possible to open this form on a specific record? from a command button on my form bound to tbl:repairs i open my form bound to tbl:sitereports and default to the site report for that repair job (linked by an id field common to both tables) i guess it involves handing a variable to the sitereport form and i cant find how one can do that. (i'm not very familiar with access) any help appreciated, vauneen If you had told us the Field names and the Control names, chances are good that someone could have given you a specific answer. As it is, please clarify the name of the Field that is common (in both Tables) and the name of the Control and Form from which the user will be selecting a particular one, as well as the Form name you want to open, and, in the meanwhile, use the Wizard to create a Command Button for Form Operations | Open Form. Then, if the Properties dialog isn't visible, right-click the Command Button and choose Properties. On the Properties dialog, click Events, and choose the Click event, then press the tiny button with three dots. In the code that is shown, place your cursor on the DoCmd.OpenForm and press F1 -- then look at the help for the Where Condition argument -- you may not even need to post back here. Larry Linson Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|