[dsenette]

i've created a form in access to allow my shipping dept. to print to a large printek printer that we have for shippers so that all the data would come out in the right places the form is actually in no way linked to a database because i don't need it to be (plus..if they press print when it's actually linked to a DB it prints the whole DB) i've got two questions here...

#1 how do i have a field in the form (it's just a text box) have an autogenerated number without having it linked to a db

#2 is there any way to get the form out of access so that they don't have to go all the way into the db to open it?

[Advertisements]

dsenette,
Your opening statement seems contradictory as to whether the form is currently linked to the DB.
I'm assuming it is because you say the whole database prints out when they press print.

To avoid printing the whole database and only print the current record on the form, you could filter on the current record

If you want an auto number, by design it would need to linked to a table.

If you don't want the form linked to a data source and don't want to open the database to access the form you can publish the form to MS Word

[dsm]

dsenette,
Your opening statement seems contradictory as to whether the form is currently linked to the DB.
I'm assuming it is because you say the whole database prints out when they press print.

To avoid printing the whole database and only print the current record on the form, you could filter on the current record

If you want an auto number, by design it would need to linked to a table.

If you don't want the form linked to a data source and don't want to open the database to access the form you can publish the form to MS Word