how to display information on a datasheet on a form

[abiola]

Please I have a microsoft access form and a table, I will like to display the information in the table on a form, I have made the form a continous form and also set the record source. When I open the form in form view it is blank,but I can see the number of records displayed at the bottom of the form and when I click next it advances to the next record but the form still remains blank. How can I get the form to display the record? Any help will be appreciated.

 

[Rabbie]

Try opening the properties page for your form and under the data tab make sure that data entry is set to No. Allow additions should be set to Yes

 

[abiola]

Rabbie, I have tried it but still no record is displayed.

 

[Rabbie]

It works for me. can you post your DB so we can see what you have got there.

 

[abiola]

Hi Rabbie, I only have a form and a table. the form is used to enter data into the table and it is the information in the table that I want to display on another form in form view. I have not written any codes or can you tell me how to post the DB here?

 

[Rabbie]

Just below the reply text box you will see the "Go advanced" button. Click that. Then scroll a little way down and you will see the "Manage Attachments" button. Click that. then you can attach your DB file.

 

[abiola]

Here I have attached the database.

 

[Rabbie]

No you haven't.

 

[abiola]

I have zipped it and attached it. Thanks alot.

 

[abiola]

Hi Rabbie, the "form 1" is the form that I want to use to display all the information in the table.

 

[Rabbie]

Check out Form3 in the attached DB. Is that what you wanted?

 

[abiola]

thanks alot, Yes that is what I want to do. So what or how did you do it?

 

[Rabbie]

Simple really. Just used the New Form Wizared to build a datasheet form using Query1.

 

[abiola]

Thanks alot for setting me on my way to the next task.

 

[Rabbie]

Glad you found it helpful. Good luck with the next bit