Forms - Modification of Wizard Database form

In order to save time I am using a Wizard database to set up my inventory but I need to make some modifications to customize the database for our use. I have changed the item id to text category so we can input our own alpha-numeric numbers. The trouble is with the data entry form. When opened, the cursor still goes to the second entry (description) and I cannot get it to open at the first entry for the item number. If anyone can give me some advice I would be very greatful.

I think you're referring to one of the templates. Be aware that if the item ID was a primary key, you need to Index the field (in the Field properties at the bottom of the Table Design View) as "Yes (no duplicates)" in order for the relationships to work.

As for the cursor tabs, first make sure that the properties of that control on the form include:
Tab Stop (Other tab): Yes
Enabled (Data tab): Yes
Locked (Data tab): No

Then go to the View menu (still in Form Design View and with the entire Form selected) and click on Tab order... There you will be able to specify the order in which the tab key traverses the controls on the Form.

Hi,

Thank you for the info. I have Indexed the filed so that should be ok. I tried what you recommended, the tabs are all in order but my form still opens at the second field instead of the first one. Is there some little switch somewhere that says "start here"? That would be nice as I am getting a little frustrated.

Yes, that's what the Tab order... window lets you do. Just move the one you want to be first to the top of the list.

I did that. It did not change anything.

With all those properties properly set, form should open with cursor in that box UNLESS there is some coding (VBA or macro) that directs movement to another box. I suspect that the template project might have that because if the ID field was originally an autonum type, would be no reason to allow users to enter that box. If you want to make your project available by uploading to a file share site such as Box.net, will look at (have to be member here 30 days or something like that before can attach files to posts). Post the link to the file.