Refreshing controls when movenext in record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Madhuri - 15 Jul 2005 17:52 GMT

Hi all

I have a form created in access and I have added a few controls which are to
be refreshed or values set. when the user navigates in the default record
navigation controls given by access

ie, the the navigation given when access table is opened up for move to next
record, last record, previous record, first record.

Where do I write the event in form code to set the values for controls which
are not connected to the database ?

Thanks
Madhuri

Reply to this Message

Madhuri - 15 Jul 2005 18:41 GMT

I got the answer.

I have one more doubt. When I open the access database a form pops up on its
own. How do I change the settings of the form not to show up when database is
opened. I wish to open a main menu form instead of the above form. How do I
change settings for that ?

Thanks
Madhuri

> Hi all
>
[quoted text clipped - 10 lines]
> Thanks
> Madhuri

Reply to this Message

Marshall Barton - 15 Jul 2005 22:34 GMT

>I got the answer.
>
[quoted text clipped - 12 lines]
>> Where do I write the event in form code to set the values for controls which
>> are not connected to the database ?

The first question - use the Current event

Second question - use the Tools - StartUp menu item to
specify the form you want to open at program start up.

Signature

Marsh
MVP [MS Access]

Reply to this Message