The problem I'm having here is a situation of updating and/or adding to existing records. So I've based a subform on a query that lists the current, pertinent records from my main table, and the main form is merely a duplicate of the original data entry form which was used to enter the data. What I can't figure out how to do is link the two so that the subform shows all of the current pertinent info and allow the user to select one of the records in the subform, and cause it to populate the entry form with the existing data, for modification. As the other option, I want to allow entry of a new dataset if necessary. The problem seems to be that if I link the primary fields of the form and subform then I get no data in my data sheet subform because the main form is blank, even though it's based on a seperate query.
Kyle B.
PS What I've got here is a forecast work entry form, where I want to allow modification or addition to work that's forecast to be completed for this month, the query merely looks in the table for existing data that is currently forecast. This data is displayed int he subform, and I want to be able to select one of those entries in the subform to modify the data, or create a new entry.
Kyle B.
PS What I've got here is a forecast work entry form, where I want to allow modification or addition to work that's forecast to be completed for this month, the query merely looks in the table for existing data that is currently forecast. This data is displayed int he subform, and I want to be able to select one of those entries in the subform to modify the data, or create a new entry.
