Linking the field of one form to a field on another form

[bradp1979]

In my office, we use one form to input allocated equipment, and another form to give those managing a specific job. The form we give to the job manager has fields indicating which equipment has been allocated to them, which was pulled from the first form using a control source. For example, on the first form, I may say that 4 jackets are being allocated. In the text field, the control source will be #Jackets. On the corresponding job manager form, that 4 will be in the jackets field.



I am trying to put new fields for allocated equipment on the first form, but I'm unable to create new control sources. For example, I'm trying to put revenue reports as an allocated piece of equipment. So I created a new field on both forms, but when I try to link them with a new control source of "#revreport", I get an error message that it is an invalid control property: control source, and "No such field in the field list"

How do I correct this?

[June7]

I don't understand the db design. If you want to provide db for analysis, follow instructions at bottom of my post.

[bradp1979]

I'm uploading a couple pictures of the problem I'm having.

[bradp1979]

Don't know if this helps.

[June7]

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

Nope, doesn't really help my understanding.

[bradp1979]

Incidentally, I figured it out. I had to open up the table where the data was being pulled and insert new columns, which I then named as what I wanted. Then, back on design view for the forms, I could link them by selecting the new values as the control source.