Search results

Thank you both for your replies. I meant to show the correlation between the 3 tables and the 3 radio buttons. This is a administrator level application so there will only be 2 or 3 people using it. The user clicking the check box and checking it is an indicator for me to update that field...

I'm working on a access application and would like the best way to achieve what I'm trying to do. I have 3 tables that have different types of data so I want to have 3 radio buttons on my main form and an ID search textbox and search button. The subform will be populated with the form based...

Thank you pbaldy, That worked perfect

Hello, I have a combo box that when changed I want to update a date column in one of my tables. The issue I'm running into is if a user selects the same value that was already selected the event fires and updates the date. I only want an update when the value completely changes. I've tried...

I have a make table query where one of the columns is left(Text,7) as Text1 Now when I view the design of the table it says the column is 255 characters long even though it is only 7 characters. Is there a way to do this through my query? I can't create the table before hand either. Thank...

scooterbug, Thank you that helped lead me in the right direction. I compare the row nums against the number of records in that subform and compare till I hit the last one and set my focus after that. thanks

Denis, How will it know that it is the last record? The same 3 fields repeat for every record and I only want to do this on the last record. Thank You

Hello, I'm having an issue with tabbing in my subform. I have 20 fields per record. I have the "Tab Stop" Set to "yes" for 17 of the 20 fields. So only 3 combo boxes are tabbed too. They are the only editable fields on the record. So after record one is tabbed through it goes to record 2...

dcb, Thank you for your response. I've used open args what I want to do is as soon as I open the pop up form I want a row to insert into table2 without writing sql code. Form1 will always have an id. I have a list of customers and the button will allow me to put a note about this customer. If...

Hello, I would like know the best way to do the following scenario: form1 is tied to table1. I have a button on form1 that when pushed a modal form will pop up with form2 which is tied to table2. Now within the relationships table1 is one to one with table2. My question is how to add a new...

Scooter, That is pretty much it. On my after update event within subform1 I do the following Me.Parent.txt = Me.id Me.Parent.frmSub2.Requery I don't have any code within subform2 Thank you

Scooter, I got it working by setting my textbox equal to my id and then requerying the child subform within the After Update event. Thanks so much so far it seems to be doing what I want. Thank You Jerry

Scooter, I'm not using my list box anymore. I'm just using two subforms with a textbox on the main form. The oncurrent event on the Parent subform fills the textbox and the Link Master field of the child subform is equal to that text box. On the parent I have two columns ID & Name. ID is an...

Scooter, When should I be requering? I notice an issue when I add a new row to the parent table. When I add a new row the ID (autonumber field) goes up by 1 and I enter my text but on the child subform it's blank and the id field isn't populated. I have to click back on the row I just added...

Scooter, That was it. I used a text box that I would fill from the person subform within the Current event. Then the shopping habbits subform link master field was the text box. I ran into this site and it said pretty much what you told me...

Scooter, How can I tie the listbox to the subforms? Thank You

Scooter, Thank you so much for your suggestions. I will try it out and let you know. Thank you again for all your help

Scooter, Thanks for the idea. It was perfect till I realized the user has to be able to add new people into the person table and new shopping habbits for the new person. So close. Is parent child my only option? I can't do continous form like that so it's one record at a time from TAB1...

I solved it by setting the value of the frame to 0

Scooter, Again thank you for taking the time out to help me. Based on your example i'm required to show all people in one subform and their habits depending which row has focus on the first subform within subform two. This layout is based on my bosses layout. He wants to see everything from...