I would like to copy commands for navigation from my main form to other forms
in the database.
Any suggestions on how to do this?
Thanks!
Beetle - 23 May 2008 19:42 GMT
Do you mean that you use your own navigation buttons, and you don't
want to rewrite the same code for each button? If that's the case you
could put navigation code in a standard module, then call it in the Current
event of each form.

Signature
_________
Sean Bailey
> I would like to copy commands for navigation from my main form to other forms
> in the database.
>
> Any suggestions on how to do this?
>
> Thanks!
Klatuu - 23 May 2008 20:13 GMT
Not enough info to fully understand your question.
Are you saying you are using custom navigation buttons on a form with VBA
code that does the navigation?
If so, put the VBA code in a standard module and copy it from the click
events of your nav buttons.

Signature
Dave Hargis, Microsoft Access MVP
> I would like to copy commands for navigation from my main form to other forms
> in the database.
>
> Any suggestions on how to do this?
>
> Thanks!
NEC-2008 - 24 May 2008 14:06 GMT
My question is simular....
What if you wanted to copy the form "content" (most of the data) from one
form to another. How would you go about that?
> I would like to copy commands for navigation from my main form to other forms
> in the database.
>
> Any suggestions on how to do this?
>
> Thanks!
Douglas J. Steele - 24 May 2008 14:17 GMT
Forms don't have data: they're just views into the data contained in the
tables.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> My question is simular....
> What if you wanted to copy the form "content" (most of the data) from one
[quoted text clipped - 7 lines]
>>
>> Thanks!
NEC-2008 - 24 May 2008 14:27 GMT
OK Mr Steele, you are correct, but the theroy is valid. The question still
stands...How would you do this.
> I would like to copy commands for navigation from my main form to other forms
> in the database.
>
> Any suggestions on how to do this?
>
> Thanks!
Douglas J. Steele - 24 May 2008 17:13 GMT
Your question would appear to have nothing to do with JR's question of how
to copy commands from one form to another. You asked " What if you wanted to
copy the form "content" (most of the data) from one form to another. How
would you go about that?"
You'd point the second form to the same table as the one to which the first
form is bound.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> OK Mr Steele, you are correct, but the theroy is valid. The question still
> stands...How would you do this.
[quoted text clipped - 6 lines]
>>
>> Thanks!
Pete D. - 24 May 2008 20:54 GMT
Did you mean copy fields from previous record to save someone from having to
type similar information a second time into the next record? If so see,
http://support.microsoft.com/kb/210236
> Your question would appear to have nothing to do with JR's question of how
> to copy commands from one form to another. You asked " What if you wanted
[quoted text clipped - 15 lines]
>>>
>>> Thanks!
NEC-2008 - 24 May 2008 22:37 GMT
Your dead on! Thanks. Will ck it out tonight. Tks to u 2 Mr Steel.
> Did you mean copy fields from previous record to save someone from having to
> type similar information a second time into the next record? If so see,
[quoted text clipped - 18 lines]
> >>>
> >>> Thanks!