Forms: Limit to one record at a time?

[caringsharingbristolbilly]

Hi to all you Access gurus in MrExcel.comland.

I've got a "survey" on a database for business users to fill in. I only want them to fill it out once. When it's opened, it goes to a new record, then filters for blank data in the "name" field to prevent users being able to see other people's answers.

How can I set it up so that once someone has entered their name, the option to move to a new record is removed? I've removed the record selectors, etc, but the wheel on the mouse still moves on to a new record...

Any help hugely appreciated...

 

[bat17]

If you set the forms "Data Entry" property to yes then they won't be able to see previous records, but you may want to tweek the toolbar to prevent them from removing filter!

If you are trying to prevent them adding a new record then you will probably be best to create an unbound form and use code to save the record when they have finished filling it in.

Peter