I'm not certain if the sub form will handle this, but I have multiple tables which I want to be able to add and retrieve information from as needed. For example I create Table "A" with fields "ID, 1 & 2" I then create Table "B" and with fields "ID, 1&2". I then create Table "C" with fields "ID, 1&2"
So far I have three tables, 9 data fields I wish to add information to. I then create a form. What I'm trying to do is make for example 3 columns where the ID is on top followed by fields 1&2 for columns AB and C corresponding to tables A,B, and C. This way I can: for column A-select the ID(just how I store my records) then enter data under that ID in fields 1&2, then do the same for Columns B's field 1&2 and C's 1&2 without adding data to the wrong column. When I tried placing two combo boxes in the same form, I'd change the one, and the other would follow, even though I thought I was pointing them to different data tables I know I just gave a mouthful but...... I wasn't sure if the subform was suitable for this. The alternative is I create 3 separate forms all hard coded for their respective tables and switching back and forth. Is it possible to do what I'm describing? Thanks in advance for any help and please let me know if the above description is too cryptic... -- Patience yields far greater results than brute force or rage ever could so relax......it's just life !!! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
