Grid Problem

[Guest_imported]

Hi All

Is it possible to add values in a Grid without any table or Cursor just like in List Box ( AddListItem ).

Actually in my Grid I have inserted 5 Columns as under:-

ITEM CODE ITEM NAME QUANTITY RATE AMOUNT

I want when user write an Item Code, Nest Column automatically filled with Item Name selecting this value from a table and Focus will set on Column No. 3 where user will write the quantity and then in Column he will write Price and then again column 5 will automatically filled with the value (Quantity * Rate)

This must be possible, please guide

Thanks in advance
Ahsan Rana

 

[DannC]

ITEM CODE ITEM NAME QUANTITY RATE AMOUNT
If you have a grid named grdValues and 5 columns like this
grdValues.ItemCode, grdValues.grditemName etc. and 5 txtboxes like grdValues.grdItemCode.txtItemCode, etc. When the grdValues.grdItemCode.txtItemCode loses focus U can fill the next txtBoxes like this. Thisform.grdValues.grdItemName.txtItemName.value = Item Name an so on.

 

[Guest_imported]

Hi Nefra

Thanks for guidance. Now the Problem is Blank Grid does not accept the focus. How I can get the focus and enter any amount in a blank grid

Ahsan Rana

 

[chpicker]

A grid cannot have values added to it. It MUST have a record source. You don't actually add values to a grid but to the table behind it. So, no, you cannot use it like a ListBox and just add items to it.

Ian