Hi Guys,
I am working on a billing database.
I have created a list of bills between specific date through a query, for which arguments are being passed by user input on main form & in subform the list is being displayed. Now I want user to be able to click on desired bill number to open the bill to that specific record and (frmSale is the form which needs to be opened) edit as per requirements. SaleID field is Number type. Textbox control on both forms is SaleID.
I have tried using following command :
="[SaleID]=[SaleID] "
="[SaleID]='" & [SaleID] & "'"
In other example I am able to achieve following through report, but the field is text type in place of number.
Awaiting your help and guidance.
Regards
Deepak Gupta