Calendar inputting date into Date field

[henry_s]

Hi,

I'm using Access 2000 with Calendar Control 9.0.

I have setup the Calendar Control on a seperate form that pops-up from the original input form if a hyperlink is clicked. My problem is this:

This works find for record #1, however if I then close the calendar pop up and move to a different record on the original form and then press the hyperlink (bringing up the pop up calendar form) it displays the date that is stored for record #1, and, if updated, changes the date of record #1 - Not the active record.

I've tried using the GoToRecord action in a macro but was unsure what I should do for 'Offset', and unsure if this action would help me at all.

MS Access Help:

You can use the GoToRecord action to make a record on a hidden form the current record if you specify the hidden form in the Object Type and Object Name arguments.

I've done this, but I'm not sure what I should do for the 'Record' and 'Offset' fields.

 

[blue2kuk]

Hope this helps:

http://www.fontstuff.com/access/acctut09.htm

Blue2kuk