Hiding a new record in a continuous form

**system243trd** · 11-30-2011, 09:23 AM

Hi,

I have a form that contains a subform. The subform is a continuous form. As soon as you enter a value in the continuous form a new record is displayed below the one being entered. Is it possible to hide the new record from appearing and it only being displayed when a button is selected or enter is pressed on the last field.

Thanks

**June7** · 11-30-2011, 03:22 PM

Yes, would require VBA code. Click a button that runs sql INSERT statement to add record to table then refresh subform and go to last record. Form AllowAdditions property would have to be set to No.

**system243trd** · 12-01-2011, 03:14 AM

Please could you provide this code as I am new to VBA.

Thanks

**June7** · 12-03-2011, 01:04 AM

Search Access Help on topic: Programming for Access. I am not able to help further for 2 weeks (vacation).

Hiding a new record in a continuous form

Thread Tools

Hiding a new record in a continuous form

Similar Threads

Hiding columns in split form.

Hiding a Column in Split Form

How to identify which record in a continuous form was clicked on?

Get position of record in continuous form

Suppress new record on continuous forms

Posting Permissions