I need some advice on creating a manifest database that autofills on a acc number.

[glenj191]

Hi, I've only ever used Microsoft access once, this was a few years back and my knowledge of Access is limited to the basics.

Basically every day we hand input atleast 10 possible 30+ address into a microsoft excel speadsheet, then print and fax to the courier company. I would like to create a database that when I enter there account code in one box, it auto fills there address and other relivant details. I've exported my Sage customer database to excel and inported it to a table in access, I've created my form. I just can not remember how to create auto fills on an account ref.

I guessing its a combo box but when i do what i think will work its not.

Can somone please help. Im using version 2003.

Regards

Glen

[ChipR]

The easiest way to do this would be to drop a combo box in the Form Header, and use the wizard with the "Find a record on my form based on the value I selected in my combo box." option.

[glenj191]

Hello, Firstly thankyou for your help. I hate to sound like a total noobie. but where is the "Find a record on my form based on the value I selected in my combo box." option located. I can't locate the wizard.


Regards


Glen

[ChipR]

Is you form bound to a table? If it's not, you won't have this option as the first step in creating the combo box.

[glenj191]

It's ok, I've done it now, I was using Design view not the widard. it work now fine. when I print will it print the form header? or just the details?

Thanks again

Glen

[ChipR]

You can set the properties for the Form Header section. The "Display When" property can be set to Screen Only, then you won't see it on the printout.

[glenj191]

Ok brill, I've just made a working versions and its all working great. However I want to be able to have four differnt companies and there addresses on the manifest, other wise its going to create a need for more paper to be used. I've tried creating other combo boxes and more fields but all it does is change both addresses and doesn't seperate for differnt companies and addresses. Do you know how I can make a combo box specific to fields I select or is there a way I can have a tick box to select what fields I'm editing?


Regards


Glen Aka Noobie

[ChipR]

Right now you are working with one recordset, and the combo box is taking you to the appropriate record. If you want to have 4 different records on one form, you would place 4 subforms on your form, one for each recordset, and link each of them to a different combo box. Then the main form would not be bound to anything, it would just contain the subforms.

[glenj191]

When I go to create a combo box in the sub form it doesn't give me the "Find a record on my form based on the value I selected in my combo box." option. Is there no other way of doing this with out subforms? it's just that I have to fit this on a A4 sheet and If I use subforms it will be huge.


Regards


Glen

[ChipR]

Make sure you get this working, and then copy the process 3 times.

1. First, the main form will be unbound. Remove the data source, or preferably just start with a new form.
2. Make a combo box on the main form (not in the header) and set it to look up the values in your table that you will select from. We are no longer using it to move to a record in the way that the wizard was.
3. Give the combo box a name that makes sense.
4. Make a subform based on your recordset.
5. Go to the subform properties and in Link Master Fields put the name of the combo box.
6. In Link Child Fields put the name of the field in the subform that will be chosen in the combo box.

Now, when you choose a value from the combo box, the subform will filter automatically to that record.

Subforms in form view do not take up the space they appear to in design view. If you can fit 4 records on a sheet, you can show them in subforms.