move to record

[spinkung]

hi

i have a form which is a list of subjects. i want to select a record in the form which then filters another form.

is there a way to move to the record on the second form without using form.Filter?? i want to be able to cycle through all the other records on the second form which isn't possible using .Filter

Thanks

 

[pr2-eugin]

I think what you want is to open another form with a condition.. check this.. http://baldyweb.com/wherecondition.htm

 

[spinkung]

thanks

the second form is already open. i have a search button which opens up the full list of subjects. i then need to select a subject a goto that record on the second form.

 

[pr2-eugin]

Did you try DoCmd.GoToRecord?? You can use that on the onClick event..

 

[spinkung]

i've tried this...

DoCmd.GoToRecord acDataForm, "frm_201_subject", acGoTo, Me.SUB_CODE

me.SUB_CODE is usually a 5 char field i.e. F0001, F0002

I don't think i'm using the GoToRecord right as above? can i use the selection value to goto a specific record?

 

[pr2-eugin]

No GoTo record is not the Value you can use.. it is the Record Number (offset value) that you use.. For example you might have the ID as 29 whereas the record number of that particular record might be 5 so in GoTo condition you should use 5 and not 29.. Hope this makes sense..

 

[John Big Booty]

You need the FindRecord method rather than the GoToRecord method