C
Christine
Hi,
i am trying to develope an application for the part
information. i would like to ask the experts here,
1. what record locking strategy i (you) should use in form
if i put a tablename in recordsource?
2. How about if i need to run an action query?
3. what if i retrieve data using VB to show 1 record on
form instead of putting a tablename in recordsource?,
set rst = db.openrecordset("tablename")
PartID = rst!PartID
PartDescription = rst!PartDescription
rst.close
rst=nothing
is that the same as #1?
Thank you very much
i am trying to develope an application for the part
information. i would like to ask the experts here,
1. what record locking strategy i (you) should use in form
if i put a tablename in recordsource?
2. How about if i need to run an action query?
3. what if i retrieve data using VB to show 1 record on
form instead of putting a tablename in recordsource?,
set rst = db.openrecordset("tablename")
PartID = rst!PartID
PartDescription = rst!PartDescription
rst.close
rst=nothing
is that the same as #1?
Thank you very much