I can't view records in my table via my form. 1

[seawave]

I have a table with 10 records in it. On my form the naviagation buttons show that I have 10 records. On my
blank data entry form, I press the "previous arrow" to view
the 1st or any one of the 10 records via my form, but
the data does not display in the form's textboxes. The previous arrow indicates that it has moved back to the previous record, but no data is retrieved.
Any suggestions?
Thank you.

 

[KenReay]

Hi

The Controls on your form do have their rowsource property set to the name of the column within the recordset don't they? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[seawave]

Ken,
My textboxes & combo boxes on the form are all unbound.
In my AddNew command button I have a code to tell the system where to store the form values in my table.
I do not use the "control source" property.

Is that my problem and is there any coding I can use to
keep my objects unbound and still view previous records from the form mode?

Thanks for responsing so quickly.

 

[KenReay]

Hi

If your form is not bound, you need to put in code on moving between rows, which will populate the controls.

If you have done this for add, you obviously know how to write the code, I would put the code in the OnCurrent event, you will probably have to trap and deal with no current record error, when inserting a new record

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[seawave]

Thanks Ken.
I'll give that a try.