Solved

transfer value to subform new record

Posted on 2003-12-03
1
267 Views
Last Modified: 2008-03-06
i've been wrestling with this one....
i have a listboxA on a mainform and a button next to it
i want on click to transfer the value from listboxA

to a NEW record on the Subform

how do i specify that it goes to a new record?

thanks for any help on this, J
0
Comment
Question by:jfgk
1 Comment
 
LVL 5

Accepted Solution

by:
DarkMor earned 45 total points
ID: 9912104
jfgk,
Is the subform in FORM  or Datasheet/Continuous, also are there other fields on the subform that need data before the record can be saved, finally can the user cancel saving the record after clicking the button.

The reason I ask these are to better help understand the scenerio.

It is possible to docmd.gotorecord, , nacnewrec on the subform and then set the value by referencing the listbox value, however knowing the structure of the subform makes a big difference

D
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Restoring a form to its default settings 3 27
Archiving Access table older than 6 months 9 38
Question about DB Schema 27 52
Access on Mouse move 5 30
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question