Search results

Pat, Thanks for your help and for showing me that I need to look at my data from a table point of view rather than from the form backwards. I was more focused on getting the data to present in a certain arrangement in the form than concentrating on sound table structure. Charlotte

Pat, Thanks for clearing that up for me. This project is for a food bank; they need to keep track of the food baskets distributed per month and to which households. The date isn't even that important, except to make sure that a particular household hasn't received more than one food basket per...

RG, It seems like the line that sets focus to the individual control is the problem, though I don't know why. Here's what I've tried in the LostFocus event of the last control of the first subfrom: Me.Parent![Names of Household Members].SetFocus Me.Parent![Names of Household...

RG, Thanks for responding. I entered the lines as you suggested, but it gives me a run-time error "Object doesn't support this property or method." What am I doing wrong? Charlotte

Thanks for your quick response. Pat, I'm not sure I clearly understand what I need to do. The table should only have 2 fields with both fields being combined as the primary key? Is that correct? "... - use 1 as the day if all you are interested in is month and year ..." I'm sorry; I don't...

How can I get some mainform fields' data to be the first entry in a subform? From the mainform, I would like the Head of Household name and date of birth to be carried over to the first entry in the HouseholdMembers subform. The two forms are tied to separate tables. For each household member...

I'm not sure if this is a table or a form question. What I'd like to have happen is that a new record will be saved for each recipient by year with the dates of service for each month of that year. Table design: DOSInd (PK) Auto# RecipID (FK) Number Year Text Jan Text Feb Text . . ...

RG, I'm having a similar problem, but I want to tab from one subform to another subform on the same main form. I can get it to do this by putting Me.Parent![subHouseholdMembers].SetFocus in the LostFocus event of the last control of subform Proofs, which is the subform I am coming out of. This...

Pat, Thank you for your help. I just went back and made forms out of the fields from the child tables and then put them back onto the main form as continuous subforms. Charlotte

Pat, I don't know how to do this; I can't find where to set master/child properties as 3 of the child tables are on the main form as a continuous form. Maybe my terminology isn't correct. I used selected fields from 4 separate tables for my main form. This was the parent table and 3 child...

Pat, I checked the AllowAdditions property and it was set to yes. I'm really not sure what happened, but at least that part is working now. My next question is how do I get the foreign key field that I added in my tables to automatically fill. I have 4 tables tied to a continuous form, but...

RG, There was no criteria set and I'm not sure why it wouldn't return any records. However, as a result of your suggestion, I went in and built and rebuilt a query adding one table at a time. This way I got records to show at each stage of the build. Then I reset the forms RecordSource to the...

RG, Thanks for responding. No, a stand alone query doesn't return any records; however, all that is in my tables is a few test records that I input before making the primary/foreign key changes. As far as I can remember, I never intentionally applied any filters, but since the copy I've been...

After reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside...

ghudson, Thank you. This appears to be doing what I want it to do. Charlotte

Thanks! I'll try it tomorrow.

ghudson, You're right, that's exactly what happened. The same as when I tried setting the field to an empty string on GotFocus and OnClick. I'm not sure how to structure the If Then test for an existing value in the memobox. I'll have to search around the forum and see what I turn up. It may be...

Pete, Thanks for your quick response; I'll try it. Charlotte

Hello, I'm new at this, but here goes. I have a memobox on a form that I set the DefaultValue to display instructions for what to enter in the memobox. I would like these instructions to be visible until the user clicks or tabs into the box. Then I would like these instructions to disappear...