MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 10:46
- Joined
- Feb 5, 2019
- Messages
- 330
Hi Forumers,
I have been reading many posts and viewing much code on here and notice the Recordset is mentioned alot.
If I have a form that cannot move between records, is there any benefit in declaring the recordset?
My frmQuote is based only on the tblQuote, and cannot move next/previous. To open a different quote to view, the form must be closed and then re-opened from a list box doubleclick. I have the below codes to edit a quote or create a new quote.
Add New - DoCmd.OpenForm "frmQuote", , , , acAdd
Edit Existing - DoCmd.OpenForm "frmQuote", acNormal, "", "[QuoteID]=Forms![frmCustomerOverview]![lstCustomerQuoteList] ", acEdit, acNormal
Would I benefit from declaring the recordset for a single record?
Does anyone have a link to a good guide to recordsets, I have looked around but not found anything that really explains it well to me, but I am sure it is something I should learn.
~Matt
I have been reading many posts and viewing much code on here and notice the Recordset is mentioned alot.
If I have a form that cannot move between records, is there any benefit in declaring the recordset?
My frmQuote is based only on the tblQuote, and cannot move next/previous. To open a different quote to view, the form must be closed and then re-opened from a list box doubleclick. I have the below codes to edit a quote or create a new quote.
Add New - DoCmd.OpenForm "frmQuote", , , , acAdd
Edit Existing - DoCmd.OpenForm "frmQuote", acNormal, "", "[QuoteID]=Forms![frmCustomerOverview]![lstCustomerQuoteList] ", acEdit, acNormal
Would I benefit from declaring the recordset for a single record?
Does anyone have a link to a good guide to recordsets, I have looked around but not found anything that really explains it well to me, but I am sure it is something I should learn.
~Matt