Search results

This is the code I used in the new combo box -------------------------------------------------------- Private Sub CboUnlisted_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[StockName] = '" & Me![CboUnlisted] & "'" If Not rs.EOF Then Me.Bookmark =...

Hi burrina Done everything as you advised. Getting the StockNames in the new combo box. However, it is not taking me to the sub form entries, nor does the text boxes in the main form change. I am attaching the db for you to have a look. Thanks.

Hi burrina I have created another combobox. But was not that successful, as it was not bringing the related sub form entries. Therefore, I went for the check box solution again and was almost successful except that, when the row source of the combo box changes to new query, it shows StockID...

Thanks again, burrina.

Hi Burrina I will try to explain . Now my combobox is based on a query which will bring only the stocks which are currently active (means qty is more than zero). However, there are cases when I want to see all the stocks in the comb box (One such case is while we add new stocks). I think this...

Thanks burrina. It's working perfectly now. Just one more help. When I add a new stock using the "Add New Stock" button, it will not appear in the Combobox suddenky, as the qty is zero. I have to go to Stocks table and add the purchase there, to get it in the combobox. Any work around using the...

I am attaching the zipped version of main db. What I am unable to achieve are: 1. When I select any stock from the combo box of the main form, it is not taking me to the new record in the sub form. 2. When I try to select the TranType in the sub form to update the records, it is not allowing...

Thanks. I will try again.

I changed all of them. But still no luck. May be I have to rebuild the db !

Hi Burrina Sorry to bother again. I tried to apply the same to the master file. But not successful, though. Could you please explain what should I change in the code/properties and where ?

Thanks Burrina. It is working fine.

I removed the go to new record from the subform and tried. Still the same result. Can someone help please?!

I can't ! I need the sub form go to the new record on load, to add entries.

I removed the Order By from frm Transactions. But still the problem persists. After choosing the stock from the main form combo, when I select Purchase from the combo box of Sub form, the cursor goes to new record. It is not allowing me to enter TranDate, Qty etc. !

I have a form with a subform for tracking the stocks trading. I use the subform to enter new transactions. This was working fine until I have made some modifications in the design, which started giving me the trouble. Whenever I try to input any transactions by selecting a combo box in the...