Solved

transfer value to subform new record

Posted on 2003-12-03
1
250 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

762 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now