Greetings.
I’m very stuck on this and I’m sure it’s easy (based on what I’ve recently read)... but obviously things are beyond my skills or my environment is actually different. (I'm sure it's me.)
Using MSAccess 2002.
I have a table of Project Meetings [OTM], containing project number [PNUM as string], meeting date [MDate as date], meeting occurrence [MO as whole number] , attendees (four different checkboxes to indicate attendance) [AT1-4 as Boolean] and meeting comments [MC as memo].
The section of the tracking application at issue allows people to add a new meeting, or to view meetings which have occurred. Now people being people, they want the ability to select a meeting to update if they see something while browsing the list of meetings for a project. On the browsing screen [View], the fields are locked to prevent accidental editing. I want to add the ability to select a meeting occurrence, pop-up a new screen [View-Edit] to edit and then return to the browsing.
I can’t seem to get the data from the browsing to the pop-up. I’ve tried public variables (and in that vein, I can’t find a datatype of memo in the VBA); I’ve tried building a select query of the fly (the receiving form doesn’t accept it as a valid data input). Anyway, perhaps you can see that I am not only dead-in-the-water but pretty hopeless as well and can really use some handy tips on how to retrieve just that record on the fly and then update it.
Thank you in advance!
LJ
I’m very stuck on this and I’m sure it’s easy (based on what I’ve recently read)... but obviously things are beyond my skills or my environment is actually different. (I'm sure it's me.)
Using MSAccess 2002.
I have a table of Project Meetings [OTM], containing project number [PNUM as string], meeting date [MDate as date], meeting occurrence [MO as whole number] , attendees (four different checkboxes to indicate attendance) [AT1-4 as Boolean] and meeting comments [MC as memo].
The section of the tracking application at issue allows people to add a new meeting, or to view meetings which have occurred. Now people being people, they want the ability to select a meeting to update if they see something while browsing the list of meetings for a project. On the browsing screen [View], the fields are locked to prevent accidental editing. I want to add the ability to select a meeting occurrence, pop-up a new screen [View-Edit] to edit and then return to the browsing.
I can’t seem to get the data from the browsing to the pop-up. I’ve tried public variables (and in that vein, I can’t find a datatype of memo in the VBA); I’ve tried building a select query of the fly (the receiving form doesn’t accept it as a valid data input). Anyway, perhaps you can see that I am not only dead-in-the-water but pretty hopeless as well and can really use some handy tips on how to retrieve just that record on the fly and then update it.
Thank you in advance!
LJ
