GetLineNumber Function

[StefanSch]

Hello

I use the GetLineNumber function stated by "Microsoft Support Center" in order to number records on a continous subform.

This works beautifully.

However, if I add new records or if I delete existing records, the numbering text box does not change or get its new value. This only happens if I close the form and load it again.

Here the question. Can I force the text box to always show the applicable number, also after adding new records or deleting existing ones?

thanks.

Stefan

 

[Rich]

Requery the form

 

[StefanSch]

Thanks I will give a try.

 

[StefanSch]

I tried to implement the DoCmd.requery command.

However, I do not know where to add it.

Can you help me on this?