I'm able to create a combo box in a form, and have one control populated. how can I do the same thing, but have multiple fields populated?
thank you in advanced
I'm able to create a combo box in a form, and have one control populated. how can I do the same thing, but have multiple fields populated?
thank you in advanced
I think that this is what you are looking for
http://www.baldyweb.com/Autofill.htm
Alan
ok. . I must be doing something wrong. . I went to the web page, and the bottom portion is me. the rare instance where I'm wanting to store info from my combo box to certain controls. maybe my confusion is what control sources your web page is talking about. I have a combo that I created using a wizard, which in turn is from a query. there are 4 columns in total. having one field populated is cake. looking at the web page, it appears all I'm needing to do is add to my "After update" field of my combo. my combo is simply named combo79. the field on my form is named "Project_no". . so, in the field "after update" in my combo, I have this line "Project_no=combo79.Column(3)" in the field "control source" of my "Project_no", it's populated with "Project Number Final" which is the name of field that is taken from my query originally.. . I'm getting myself confused.
thanks
also, I'm getting an error "cant find macro "Project_no=combo79"
Suggest you upload a copy of your db. Easier to figure out working with real situation versus a theoretical situation. Seeing the whole picture is much easier to analyze.
ok, I couldn't upload my files. . they are all over 7 megs, with multiple links to different files. . but I did some screen prints. .hopefully it speaks for itself
thanks
Really not enough information for me and it is small and difficult to read. Suggest you make a copy of the db. Delete all but a few records for testing. Run a compact and repair to slim it down and then zip it so it is small enough.
Alan
ok. . here it is. .I created a new database, inserted just what I needed to, and stripped everything down. . hope this helps
I am sorry, but I have not ever seen a set up like yours. I cannot follow it. I cannot find any VBA behind your form or figure out how your lookups work.
I usually work in an environment where the form is bound to a table. Lookups are based upon other tables and this was the premise I was working on for your situation. Honestly, I don't know how to help you with your current environment. Hopefully, someone else with more expertise than me will jump in here and help.
Good luck.
Alan
that's ok. . .I'm self taught, so I'm sure it's not the normal. . you did however give me a starting point. .in that web page you had instructions to add code to certain fields. . my questions were which text boxs was it referring to.
thanks for your help