? on default textbox value to query criteria

[eliotchs]

Hi



So now that I have the SEQ setup for a new record I am running into moving the CLINO to the new record..

The form has a criteria (passed value, if it matters) of "CLINO"

The query picks up all the records for that CLINO

in the form I use the next record button to go through the records
but once I hit a new record I want the CLINO to use the passed criteria or the field in the query that has the CLINO, since its the same

Hope this makes sense ....

Thanks
Joe

[ItsMe]

Not real clear but...

You can use the On Current event to pass field values to variables and vise versa.

strCLINO = ""
if Me.NewRecord = false then
if not isnull(Me.CLINO)
strCLINO = Me.CLINO
end if
else
Me.CLINO = strCLINO
end if

[eliotchs]

Im not sure if I am doing this wrong ..

Here is what I need

the form gets the CLINO from the parameter in the query

I am using the record selector button go through the records and to add a new record.
I need to pass the CLINO when they add the new record.

I'm thinking I can use the previous records CLINO since it is only one CLINO, maybe set it as the default ?

Just not sure how to setup

Thanks

[June7]

Maybe should be using form/subform arrangement?

[ItsMe]

...maybe set it as the default?

Thanks

Still confused. You can use literal values as a default value for fields and controls.

[eliotchs]

I did go with the form/subform, but is there a way to limit it to add only one record on the subform instead of it wanting to add another after it tabs through the last field?

Thanks

[June7]

Maybe set the subform's Cycle property to Current.