Show a combo box only on new record

[Albano]

Hi,

I have a "Continuous Forms", and i whant to show a combox only on the new record, and hide on the existing records, can this be donne?

Thanks,

Albano

 

[PHV]

In the Current event procedure of the form:
Me![name of combo].Visible = Me.NewRecord

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Albano]

I can use that solution, but it's possible to make the combo allways invisible on existing records?

 

[missinglinq]

Sure, just a slight tweak here:

In the combobox's Properties Box goto Format and set

Visible to No

Private Sub Form_Current()
  If Me.NewRecord Then
     YourComboBox.Visible = True
  Else
     YourComboBox.Visible = False
End If

Now it'll only be visible on new records.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

I assumed that PHV's answer wasn't working from your followup question, but it should work just fine (and it's shorter!) Are you having probems!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Remou]

Has anyone tried the solution offered by PHV? I think you will find it does exactly what is required, but on one line as Me.NewRecord will evaluate to true or false accordingly.

 

[IGPCS]

will this work on a continus form? phv or missingliq solution?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[TheAceMan1]

[blue]will this work on a continus form? phv or missingliq solution?[/blue]

[blue] A new record is a New Record in any view! . . .[/blue]

See Ya! . . . . . .

 

[IGPCS]

but as its a control object on a form once its visible its visble all the continus forms unless its in the form header or footer

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY