Navigating records from a alien form???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yooper_ssm - 10 Apr 2005 21:55 GMT

Group

Problem:
I have a form with a subform on it. From the parent or main form I open
another form using a command button is it possible - from this form that I
just opened – to use the DoCmd.GoToRecord , , aclast to navigate records on
the first form?

Diagram

Form 1 contains a Subform which is a continuous form. It has strService,
dtmDate, strServiceNotes. From a command button I open form 2.

Form 2 has a list box that allows you to select a new date for a service.
When you select the date and hit OK it copies the dtmDate into a table to
create a new entry. The Ok also does some other things of which work fine.
What I would like it to do is to use the DoCmd.GoToRecord to navigate through
the dtmDate record of the subform contained on Form 1.

I have tried to getfocus first then navigate. It doesn’t seem to work.

Thanks

Mike Sun d man

Reply to this Message

Pat Hartman - 10 Apr 2005 23:26 GMT

I think that there are better solutions than stepping though a recordset
opened by another form. Why not just open the recordset yourself in a
query?

> Group
>
> Problem:
> I have a form with a subform on it. From the parent or main form I open
> another form using a command button is it possible - from this form that I
> just opened - to use the DoCmd.GoToRecord , , aclast to navigate records

> the first form?
>
[quoted text clipped - 14 lines]
>
> Mike Sun d man

Reply to this Message

yooper_ssm - 11 Apr 2005 03:51 GMT

Pat

Actually i'm navigating them just before I close the form. The "alien" form
enters data - a date from a list of dates for the next 30 days. The only
reason I navigate the records on the subform of form1 is that they need to be
requeried and when they get requeried the cursor ends up in the wrong spot.

Example of how the records look

dtmDate

1/1/05
1/15/05
1/20/05
2/3/05
2/7/05
2/20/05
3/2/05
3/17/05
3/25/05

when they are requeried the cursor ends up at the top of the list. I need it
to end at the bottom. First it has to go to the acLast record then I navigate
4 previous this bring the data in the form down to the bottom. Then I
navigate 4 next to leave the cursor in the last record.

Mike Sun d man

> I think that there are better solutions than stepping though a recordset
> opened by another form. Why not just open the recordset yourself in a
[quoted text clipped - 26 lines]
> >
> > Mike Sun d man

Reply to this Message