Stop showing (AutoNumber) in field

[andyswinburne]

Hi,

I have a table with the ID calculated by an autonumber, I have a query to return a few records and I just wondered if anyone knew how to stop showing the blank record with just the ID field showing (AutoNumber)?

cheers Andy

 

[dan-cat]

go to your query proerties and change the recordset type to snapshot

 

[andyswinburne]

thanks that did the trick,

cheers dan

 

[dan-cat]

thanks that did the trick,

cheers dan

No worries

 

[andyswinburne]

hi,

just a note to anyone else who is having a similar problem. Changing the record set worked for the query but then when using the query as the source of a form i couldn't enter data.

It worked just changing the 'Allow Aditions' property to False, then data can still be enter but no new records added and leaving the record set as Dynaset.

cheers

andy