Link_Criteria HELP PLEASE

D

d9pierce

Hi all,
I need some assistance if possible.

I have several froms that I need to link the same infromation to on a
single form. I need to link the following:

Companytype which is CBO
CompanyName which is Txt
CompanyAddress which is Txt
city which is Txt
State which it Txt
companyZip which is CBO

I have a main form which I can link by using defaults on the form
desired. I have read hundreds of posts and tried many examples but
nothing seams to work. Now, the frm_company_contacts is the desired
from to link the information above to. It is made from a query. The
frm Company_Main is made from a query also. the forms work great but I
can only link the information to frm_company_contacts by using the
default on each line such as =[forms]![company_main]![companytype].

This works good but I need a code that wil allow me not to use the
defaults and be able to access this from different forms and be able
to add, edit, and ... I have gotten it to link but not to allow me to
add new. I dont want to use Cbo boxes to obtain this nor do I want the
user to be able to change so they are all locked. I just need to link
those fields to this one form.

any help would be desparately needed!

thanks so much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help me choose a product for the task 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
CmdButton to open form and Filter 0
Combo Box Changing Values in Table - Still Can't Make It Work 2
Disable mouse on form 1
Cbo box Limit to list = No write question 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Cmd Buttons and Args 7

Top