Forms editing data

W

wthoffman

How do I get the data already entered into a record to show in the form so I
can edit the data in the form page. The forms are set to continuous forms.
Also the forms do not scrool.
 
W

Wayne-I-M

How do I get the data already entered into a record to show in the form so I
can edit the data in the form page.

Assuming that the form is bound to the table/query containing the data
Open the form in design view
Ensure the controls are bound to specific table/query fields
If they are
Open the form in normal view and edit
If they are not
In design view open the property box for each control
Set the source of the control to a table/query field
Open the form in normal view view and edit

If you don't have a form
Create a query from the table data - use a wizard if needed
Create a form from the query - use a wizard if needed
Edit the form
Also the forms do not scrool.
Open the form in design view
Open the form's property box (by right clicking outside the details area)
Set the sroll bar to vertical = Yes
 
W

Wayne-I-M

Just had a thought

Ensure the form is "not" set to Data Entry = Yes

Open the frm in design view and select the Data column to check this
 
M

Michael

wthoffman said:
How do I get the data already entered into a record to show in the form so
I
can edit the data in the form page. The forms are set to continuous
forms.
Also the forms do not scrool.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top