Search results

Hey guys, I have a main form with tabs that contain subforms. What I am trying to do, is an if statement. If a value in a certain field in the main form = "somevalue" then a control on a subform becomes visible. Where would I code this anyway? I'm guessing in a query.

ahhhh THANKS! Okay, I found the problem. Lets say I open a new student record and add n subjects. I then reopen that same student back up later, and I am in fact viewing the first subject the student takes, which is why when I delete the first the subject in the 1st form, I am overwriting it in...

Hey, thanks a lot for the advice!!! I believe I have one last problem. When I enter a record into a subform, there is another subform below it that displays the information input into the 1st subform. When I input data one after another without closing the form, it works fine. But if there...

Hey guys thanks a lot for the help, I have come a long way due to your help. Now I wanna accomplish something else. I have two subforms. One that takes in data, and the other shows data. I click a button to add record from the first subform and it does what it needs, but I can only see if it...

Hey guys, sorry to nag. But I am stuck. It seems way to simple to be having such a problem. I simply want to use numerous tables and input data into those tables through a form that has sub-forms. The question is, how do I relate the tables. Id -> Id etc... or do I go another way, because I am...

Thanks a lot guys. I got my sub forms made and they are included in my main form and they look the way I want. I believe my relationships are still really messed up. Now when I goto enter information into one of the subforms I get the error "The changes you requested to the table were not...

Hey guys, I am completely new to all sorts of databases. I am trying to develop a test one for students. My problem is, I have 5 or so tables consisting of, personal information, academic information, emergency contacts, and some other stuff... I made a form to input the information but I am...