Creating a Control Group in Access

Question

Hi...I am one of those people who know just enough to be dangerous...

I have a database that I use for my business (Musical Instrument Repairs) that someone set up for us about 7+ years ago. It is an awesome database and I don't want to change what it does...but am constantly looking at options for my business.

Some of my customers use a ID number (generated at their end). I want to add Control Source to put in a box with this identifier number that can then be entered into the Form View & printed on a set Report.

Any help appreciated.

Answer 1

It's not automatic. You have to either drag the field from the available fields list or ploace a control on the form, then set the Controlsource.

Thanks for trying to help....I really appreciate it!

I think what I am struggling with is how to set the control source...

How do I get the field to appear in the Control Source option?

Answer 2

It's not automatic. You have to either drag the field from the available fields list or ploace a control on the form, then set the Controlsource.

Answer 3

I use the a form to search for instruments, then go into another form for further information on a specific instrument, then different tables to print out the log for the client.

Form 1

Form 2

Table Example

I want to have another field on the first form that I can use as a control source for populating on the Table.

I can add the field, but it is not coming through as a control source.

Thanks for any help.

***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

Answer 4

If you want this ID number associated with customers you have to first add a field for it to your customer table. Then you can add a control bound to the field to your form and reports.

Answer 5

Should the ID number be stored in a table, or is it just for one-time use?