Pulling data to another form... - Microsoft Access / VBA

David

Hi,

I have a form which requires Serial Numbers to be loaded from another
form.
When I press a button, another form opens with a list of Serial
Numbers.
I have the record selectors enabled.

I want to select a serial number range with the record selectors then
press a button called 'LOAD'. The selected Serial Numbers should then
be copied into the required fields on the first form. The pop-up form
should then close.

PSL_F_Serial copies to FirstSerial
PSL_L_Serial copies to LastSerial

I have tried the following in the 'OnClick' event ...

Forms![Shipments]![StockMovements].Form.SetFocus
[StockMovements].Form![FirstSerial].SetFocus
[StockMovements].Form![FirstSerial].text = Me.PSL_F_Serial.text
[StockMovements].Form![LastSerial].SetFocus
[StockMovements].Form![LastSerial].text = Me.PSL_L_Serial.text

I just get strange errors.

Appreciate your help.

David

Nov 13 '05 #1

Subscribe Reply

2425

Paul

It would be better if you used a RecorsetClone.

You could select/filter the records on Form1, then use the RecordsetClone to
add the records to the table/query which is the source for Form2, then
requery Form2 and close Form1

HTH
Paul

"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...

Hi,

I have a form which requires Serial Numbers to be loaded from another
form.
When I press a button, another form opens with a list of Serial
Numbers.
I have the record selectors enabled.

I want to select a serial number range with the record selectors then
press a button called 'LOAD'. The selected Serial Numbers should then
be copied into the required fields on the first form. The pop-up form
should then close.

PSL_F_Serial copies to FirstSerial
PSL_L_Serial copies to LastSerial

I have tried the following in the 'OnClick' event ...

Forms![Shipments]![StockMovements].Form.SetFocus
[StockMovements].Form![FirstSerial].SetFocus
[StockMovements].Form![FirstSerial].text = Me.PSL_F_Serial.text
[StockMovements].Form![LastSerial].SetFocus
[StockMovements].Form![LastSerial].text = Me.PSL_L_Serial.text

I just get strange errors.

Appreciate your help.

David

Nov 13 '05 #2

Similar topics

2989

Pulling data from another table, making link dynamic or static

by: piscogirl | last post by:

Hi there, I am about to build a small db in Access. Among the tables I plan to have are a Person table, an Event table, and an EventRegistration table. The EventRegistration table will...

Microsoft Access / VBA

6428

Pulling data from Access database into Intranet?

by: Stewart | last post by:

Hi there, I have an Access database, which contains the details of company staff and services. The plan is to extract data from this database onto our forthcoming Intranet (no inserting,...

Microsoft Access / VBA

1602

Problems pulling info from Form1 to Form2

by: wanyok | last post by:

I thought I had it figured out but I'm still getting errors :( I would appreciate any help I could get. I have two forms: Form1 and frmVerify. Once the info gets submitted on Form1 its text...

C# / C Sharp

1532

Need help with form pulling from multiple tables appending to another table

by: HydroPnik | last post by:

Hi all! What a great community you have here. Being an Access newbie I have already used much information gleaned from the other posters for my current project. I have been tasked with creating a...

Microsoft Access / VBA

7854

Pulling Data from Sub Form with an Append Query

by: kabradley | last post by:

Hello Everyone, So, thanks to nico's help I was finally able to 'finish' our companies access database. For the past week or so though,I have been designing forms that contain a subform and an...

Microsoft Access / VBA

2708

Pulling data across multiple forms in Access 2003

by: Himmel | last post by:

Hello, I have a database form that has a tabs control, and on each tab is another form. Each form pulls data from a different query. For example, tab 1 may list personal information (form1),...

Microsoft Access / VBA

1693

Pulling record info from a tabular form in Access 2003

by: Himmel | last post by:

I may be brain-fried, but I could use some help again. One of my glorious forms in my multi-form report thingiemajigger is a tabular form. For example, it shows customer items purchased and the...

Microsoft Access / VBA

3293

Pulling data from my subform into main form on the fly...

by: theaybaras | last post by:

Hi everyone, You've all been such a huge help to me since joining, and I'd just like to take a second to let you know how much I appreciate it! That said, I have another supplication! ;) I have...

Microsoft Access / VBA

4083

"Pushing" and "pulling" data to and from a web server

by: BobRoyAce | last post by:

I am using Visual Studio 2008 w/ VB.NET. For the database, I am using SQL Server 2005, which is running on a dedicated server box. I am creating a WinForms application for a client. It is run...

.NET Framework

7105

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

6967

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7180

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7341

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5439

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4870

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4564

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

1381

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

266

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General