By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,222 Members | 1,728 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,222 IT Pros & Developers. It's quick & easy.

Pulling data to another form...

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.