Hi All

I trying to find solution to this

When button_1 clicked

it must sets price of specific item in a sub form specific row using
following code
Forms(formA)(formB)!Price.SetFocus

But it always set prices of first row of formB instead of setting price for
3rd or 4th row of sub form

so Is there anyway I can set set focus to
formA > subform (formB) > row (2) in subform

I did find this article but it didn't help to that level

http://msdn.microsoft.com/en-us/library/aa195905(office.11).aspx

You didn't mention what type of sub form this is. If it is a continuous form, then the answer is no.

Can you post more info?

mmcdonal

Look it up at: http://wrox.books24x7.com

This subform A is continous form,and display number of purchased items in sales order.
This subform Ahas price box text field when cursor is at this textbox and pressing F5, it display another form C which displays price list and user can pick price from that form by click Paste price. and Price will appear on subform A price box.
But problem is it always paste price in very first row of continous form instead of setting price for 2nd or any other row

Some more questions:

Do you want this to be the default price in subsequent rows as they are created, or just to rows already created in the subform? It sounds like you want this price to be reflected in every row, but I am not sure if the rows are created yet.



mmcdonal

Look it up at: http://wrox.books24x7.com

Top Here is Main Order form
----------------------------------------------This is continous Sub form-----------------------------------
Item No Item Name Item Decrciption Item Quantity Item Currency Item Price Item Despatch Date
 1 XXX Technical Part 10 £ 1.1(*Here you press F5)16/05/08
 2 XXX Technical part 5 $ 2.1(*Here you press F5 again to get price for this item) 17/03/09
 3 New Line New Line New Line New Line New Line
* when we press F5 subfrom pops up and click button to paste price to Item Price field

In Access 2007 the F5 key executes a data refresh of the form.

Therefore when you press F5 the currentrecord in the subform is reset due to the data refresh.

To solve this you need to cancel the data refresh as follows:

Wherever you have the code in for F5

If KeyCode = 116 Then 'Do Something ------------

Replace with

Private Sub Price_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 116 Then
    'Do something
    KeyCode = 0
End If
------

I hope this will help others encounter same issue