Changing an action on a record on a continuous form!

[Metalheed]

Help..

I need to setup a function on a form which is set to continuous. I would like a the contents of a combo box to determine what appears on the form.

I am currently using the following

if combo1 ="New" then Newst1.visible = false
if combo1 ="New" then oldst1.visible = true
if combo1 ="old" then Newst1.visible = true
if combo1 ="New" then oldst1.visible = false

When the combo box changes it changes all of the records not just the record currently selected.

Any help would be greatly appreciated.

Chris

 

[Oldsoftboss]

I think it is an access bug. Pat Hartman posted a fix (I think) but after searching I can't find it.

Sorry,

Dave

 

[unclejoe]

Hi,

Try Here

Look for conditionalformating.

Help..
I need to setup a function on a form which is set to continuous. I would like a the contents of a combo box to determine what appears on the form.
I am currently using the following
Chris

 

[Metalheed]

Ive already had a go at the conditional formatting! Which im using for other things i.e highlight someone who has left the course.

Still stuck my initial problem though!

 

[unclejoe]

Hi,

Go Here

Ive already had a go at the conditional formatting! Which im using for other things i.e highlight someone who has left the course.

Still stuck my initial problem though!

 

[Metalheed]

Hi,

Go Here

thanks - but theres nothing there (i can see that can help) and the forums are empty! :-(

Chris

 

[unclejoe]

Hi,

Not the forum, on the left frame of your browser there is a Blue Bar "Menu", click on "+" - "Sample Files" - "+" - "Main" - "+" - "MS Access" - Click "Forms".

thanks - but theres nothing there (i can see that can help) and the forums are empty! :-(

Chris

 

[GaryPanic]

Lets have a go -
I have doen this (probably the wrong way) but it works
on my sub-table I have a couple of field that tie to the combo box
and on the after update on the combo box they populate these fields
lets keep it simple
if on your combo box one of the selects is green then the table popsulates green in the extra field - then the on currenct propties of this field do the action if green then xx if red then zzz