Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking a premade form to another form/table

Status
Not open for further replies.

KEJ99

Technical User
Aug 4, 2003
5
US
Everywhere I look I see how to create forms, but what about if I already have a form I created and used in another db and want to use this same form to present data from an another form/table.

I made an "entry form" so data can be quickly entered. However, there is a specific "state" form I created earlier in another db to use for a state agency. I copied and pasted the form into my new db. But I can't get the fields to link. Properties list is not available to me. I've tried (taught myself) to create an expression that makes the data control source the form field value. That's doesn't work (though I could be doing this wrong). I can't create a new form using the table b/c the "entry form" has list and combo boxes which can't be seen on the state form.

So ideally, I'd like the record choices from my "entry form" to present themselves on a new, already created form. Suggestions? Please! I've been puzzling over this for days.

Thanks.
 
hmmm...a little confused. so you've imported in a form made in another db. you need to then make sure the record source of the form and the control sources for all the controls on the form are altered to accomodate any differences in your table structure from that 'other' db to this one. not sure what you mean that you cannot see the properties list? how different are the table structures in the two db's? have you changed the recordsource of the form? can you see the Field List and make all your controls work properly?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top