Using Check Box to Fill Data

[boss1982]

Hi All,

I need your help please, I have 2 tables; one of them is contain Auto Number and other one contain fixed data.

i want in someway when i am in the first form (first table) will let me filter for example number 20 then to open the other form for the second table to let me choose which data i want through check boxes, and what i selected through check boxes will be filled in form number 1 (table number 1).

summary; instead to do data entry, the check boxes will be more faster.

thanks

[alansidman]

I am having some difficulty in understanding exactly what you are looking to do. I think that this can be resolved using VBA and the Case Select functionality. Look at this link on how to employ Case Select.

http://www.techonthenet.com/access/f...anced/case.php

Set your checkboxes within a Frame and use the Options

[boss1982]

lets say i have two forms;

1=

column 1: 1,2,3,4
column 2: all rows empty
column 3: all rows empty

2=

column 1: Hi1, Hi2, Hi3, Hi4, Hi5

when i am in form No.1, will open in somehow another form for 1- if i click in check box or option will let me select for example Hi2 and Hi3 from form 2, and the form 1 will be filled like the following;

first column = 1
second column = Hi2
third column = Hi3

hope you got my point

[alansidman]

Is this an excel or Access issue. You have posted in the Access forum but now you are talking about rows and columns. There are no rows and columns in Access Forms. There are labels and controls, so now I am very confused. Perhaps you should upload a sample copy of your database to avoid further confusion.

[boss1982]

please check the attached "test" database.
Test.zip

check the form "Page", if you select for example Chargehand, Foreman & Pipe Fabricator; it will be like this in the table

1.png

i want it to be like this;

2.png

i mean each selection from the combo box will be inserted in new record not like separator.
if it is not possible to do it with combo box, please advise if there is any macro can change the separator to new line (record/row)

thanks

note: if it is not possible at all to do it in access, is it possible to be in excel?

[alansidman]

I have never seen anything like this before. If I were to guess, it appears that the field in your table is set to multi-value, but I cannot see where that is set. Additionally, you have set your lookup in the table. This is definately an Access NO-NO! All lookups should be set up in your form. Read this about that subject -----> http://access.mvps.org/access/lookupfields.htm

I don't know if this is the root of your issues, but I would start with setting up the lookup in the form. Secondly, if your field is set up as multi-value, I would eliminate that and make sure that only one value per record field is input. The multi-values works against normalization. Read about normalization and data base fundamentals by clicking in the link in my signature block.