Search results

Not sure if I'm just not getting what you are saying but that seems very clunky and doesn't seem to be working. the data entry form I created does launch. the very first time it even launched with the right Vendor name in the VendorName field and the text I had typed in the Category field. so...

OK I found the place in the properties you are talking about. Right now I only have the one form which actually contains the Combobox so that doesn't make sense (at least to amateur me). Instead do you mean for me to make a Form whose purpose is to add records to tblCategory? In fact I think...

Do you mean change the property to allow additions? I thought that in that case the underlying table. TblCategory would not get updated.

Wanted to add that I tried getting rid of the primary key to add simplicity but that caused other issues so I have abandonded. And I don't even think it would solve it anyway.

I am wanting to allow the user to update (add) a category. There is a tblCategory that has three field: ID (primary), VendorName and Category. the Combo box opens only the categories associated with that vendor. Through the help of these threads, we got that to work. this is a Row Source...

The data we are allowed to pull is in Excel so I would have to first convert to csv then import. but I'll keep it in mind if I have more troubles. For now I think I've worked around it.

Thank You for the clarification. I ended up deciding I would try to get by with just a category for now and see if there is really a demand for a subcategory. If there is I will pull out this advice and apply it.

I don't use "charfld1" but I was able to get to that data at the source and get it changed(deleted). It was just a couple of records with some randomn data so I am thinking now the problem will go away. I am appending to the table. The overall idea is to use the form you have been helping...

Seems like more of a nuisance but wanted to check with the experts. I import data from a source that I have no control over and all seems to work well in terms of database function. The issue is that I get an Import Error table added each time I import. I look at them but I don't get any...

I could go to single form view instead of tabular format. There is a little value in seeing multiple records at once but not a lot. So there is an alternative if the tabular format won't work.

Thank You. does your info still hold if I am NOT using a SubForm?

I may need a little more help. I thought I could that the same concept you all helped me with and extend that to the next combo box in line which is subcategory. I guess I was wrong. Somehow I wasn't able to do it. Please take a look and let me know where I went wrong. Basically SubCategory...

I tried a couple combo boxes and that seems to be working. Thank You. I'm thinking the same solution should work for the Sub Category. I'll try that and let you know how that goes.

Here is the database. Some data is mildly sensitive, please don't share.

I have a combo box which I want to provide categories based on the name of the vendor. If I literally put the name of one of my vendors in the Row Source query it works. When I put the name of the control the vendor name should come form I just get no nothing in the combo box (nothing passes...

For clarification, I am not deleting any records, they just don't show up after a requery because the query the form is built has a filter that disallows 'Ignore' or 'Closed' values in the Decision field. I'll come back to this later to work on the out of the ordinary situations like the Zero...

I tested and found the cursor just goes to the first record. OK for now but I will go back and probably have it go to the previous record if at the end of the list. and yes I suppose I may eventually need to deal with a situation where there is only one record. And probably a check to not...

OK, so it seems you giving advice on dealing with what happens when I am on the last record. I could add another Temp Variable to record mrr-num for the last record then I could use an If then to do diff behavior to avoid the error from trying to move past the last record. I'll try that our...

Gasman inspired what I think is a solution. I had to move to the next record, store the mrr_num in a Temp variable then I also had to store the Decision in a Temp variable as well. I'll test some more today to see if I run into any issues. I suspect I may find trouble if I am on the last...

Actually I just realized that it would NOT be the next one numerically. However it should still be the Next record in the Query that is the Source for the Form.