By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,570 Members | 970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,570 IT Pros & Developers. It's quick & easy.

Subforms - populating and updating

P: 10
I hope someone can help me with this.

I have an input form with a subform that opens up in data sheet view. The subform is called based on 2 fields - BusinessName & Commodity - in other words whatever business name and commodity is selected from the drop down on the input form, the corresponding records from the contract table show up in data sheet view. Then I have the ability to select a contract that I want to use from the data sheet by clicking on the + symbol. The contract form opens however if the recordset type on the contract subform is set to Dynaset or Dynaset(inconsistent updates) the contract form is not populated with the information that I can see for the particular contract on the data sheet. If I have the recordset type set to Snapshot, the the contract form populates with the appropriate data however I cannot update the data.

I need the contract subform to populate with all of the data in the selected record, and need the ability to also update the contract when it is selected from the datasheet view of the subform.

Does this make sense?

I wanted to attach a copy of the db to this post but I'm not sure how to.

Thanks,

JMC
Jul 10 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I hope someone can help me with this.

I have an input form with a subform that opens up in data sheet view. The subform is called based on 2 fields - BusinessName & Commodity - in other words whatever business name and commodity is selected from the drop down on the input form, the corresponding records from the contract table show up in data sheet view. Then I have the ability to select a contract that I want to use from the data sheet by clicking on the + symbol. The contract form opens however if the recordset type on the contract subform is set to Dynaset or Dynaset(inconsistent updates) the contract form is not populated with the information that I can see for the particular contract on the data sheet. If I have the recordset type set to Snapshot, the the contract form populates with the appropriate data however I cannot update the data.

I need the contract subform to populate with all of the data in the selected record, and need the ability to also update the contract when it is selected from the datasheet view of the subform.

Does this make sense?

I wanted to attach a copy of the db to this post but I'm not sure how to.

Thanks,

JMC
See this link for situations where a query is not updateable (click the hyperlink for Data Can Not Be Updated) ....determine which, if any apply to you and see if Microsoft has identified a resolution that you can implement. If you need more help, please get back to us with more details on the specifics of your application (your sql code, etc).

http://support.microsoft.com/kb/304473
Jul 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.