Recent content by jaeezzy

ya.. but the problem is to select the particular index of combo box (combo box will already have vlaues initialised when the form first shows up which corresponds to orders in the record). So the values are already there in combo box, i just have to select index related to order number entered...

yes exactly.. the thing is combo box has different key to search with and textfield has different key word for example textfield will search with the order number and combo will search with details like days waiting for order to dispatch and number dispatched (this details reflect the particular...

ya may be but in my case combo box contains computed values of the orders in this format: 4 ordered, 2 waiting, 8 available now when a user selects such value from the combo box corresponding order number is displayed in the text box but if a user knows the order number he can simply enter the...

thanks for the reply neileg. Actually i'm trying to make a form where there is a combo box and a textfield and user can either select value from the combo box or enter something in the text box to retrieve records. when value is selected in the combo box, order number is displayed in the text...

thanks for the reply but it couldn't help me here's how i've done: cval=Me![combo].ListCount if cval > 0 Then for ctr = 0 to cval-1 if Me![combo].column(1,ctr)=Me.txtordernbr Then ..select that index where order number from txtordernbr field is present in the combo box End If Next...

Hi, I was wondering how can I display a certain index in a combo box to show up after I click a button. For eg: a combo box has values 0) Water 1) Rice 3) Curry and the default value is set to "". So, when I click a button how can I make any one of three show up? Also, where can I find API...

ya,maybe it would have been easier but i have no choice its part of my assignment. anyways thanks for the help..

Hi neileg, thanks for the effort. Ya I'm using form and it has a subform which will display users which and how many items are due for a particular order number. A form also has the following to record dispatch details: >Two text boxes for getting dispatch date and consignment ID from users...

Thanks for the reply neileg. As I'm new to access can you please let me know how is that done? I haven't made any form/subform for it coz it will be direct going to the tables. Thanks...

Hi, I've two tables: Dispatch ----------------------------------------------------------------------- DispatchID | CustomerID | DispatchDate | Service | ConsignmentID ----------------------------------------------------------------------- 1 1 2008-07-04 Zippy...

I think you misunderstood me. What I meant is I have a subform and have a query for it as well. Subform will display three columns from different tables. They are: "Description", "Due", "Dispatch". Description and Due, I could easily retrieve from the tables but regarding Dispatch what I have to...

Hi, I have a subform, It displays three datas, Description, Due and Dispatch. Now what I want to do is, I want the subform to display both "Description" and "Due" and in "Dispatch" I want users to be able to edit so that when a "Save" button is pressed I can update "Dispatch" column of the table...

Hi, I have two text fields one named ordernbrfield is on the form (Dispatch) and the other named numberfield is on a tab controller named tabctrl which resides on the same form, Dispatch. I used: Me.ordernbrfield=comboboxname.field(1) // Works fine Me.numberfield=comboboxname.field(2) // Doesn't...

Hi, again got in problem. How do I do with the textfield when its in the tab controller in the same form. This code: Me.textfieldName = comboboxname.column(number) didn't work for the text field inside the tab controller. I tried entering the tabcontroller name but when I enter...

Ok, I sorted it out. That was hell easy but until you don't know the way it can make life hell. Thanks..