Data Enry Forms

  • Thread starter Thread starter dzirkelb
  • Start date Start date
D

dzirkelb

I want to create a form that enters data into a
table...but, I don't want the form to display all the
information of the table.

The form will have approximately 7 fields..the user will
add whatever data is present, click on a button to add
record, then the form will put the data entered into the
table.

I can accomplish this but I can't set the form to not
display the current records in the table.

Help! :)
 
dzirkelb said:
I want to create a form that enters data into a
table...but, I don't want the form to display all the
information of the table.

The form will have approximately 7 fields..the user will
add whatever data is present, click on a button to add
record, then the form will put the data entered into the
table.

I can accomplish this but I can't set the form to not
display the current records in the table.
Click to expand...

Set the RecordSource of your form to a SQL statement like...

SELECT * FROM YourTableName WHERE 1 = 0

In the AfterUpdate event of the form put code...

Me.Requery.

You could just set the DataEntry property of the form to True, but this still allows
users to see previous records by removing all filters.
 
Setting the data entry property to Yes worked for me!!
I had the same problem.
Thanks Rick
 
Back
Top