Recent content by hunterjj

That is why I wrote this thread in the 1st palce.

This helps, but it doesn't answer the question: How do I get the drop-down to stay at the last customer I processed instead of starting over at the beginning?

No, it is not requeried or reassigned anywhere in the code. I asked how would I do a requery or a reassignment?

How would I do a requery?

I have a ComboBox that has a query for the RowSource. It selects all customers that have a certain salesman code. I then pull down the list of customers and select the 1st customer that I want to place an order for and enter my order. At the end, I tab over the last field and my ComboBox goes...

I am trying to come up with a program that will perform golf league secretary functions. My form would contain Name, Flight, Holes(1-18), Total, Handicap, and Net. I need this for as many as 24 golfers per page, and virtually unlimited number of glofers.

I have not had any schooling on this. I just picked it up from examples of other code, plus I figured some of it out on my own. As I said earlier, I never heard of datasheet processing, and I don't know how to proceed without some kind of example(s).

In my main system, I have used: 4 Tables Recordsets 6 Queries 13 Forms Multiple Combo Boxes 4 Modules Lots of Visual Basic statements Some SQL Statements

I don't know how to define and/or use a datasheet. Help, with an example, would be appreciated.

Does anyone have any info on how to define & process 1 or more 2 dimension arrays on a form?

If you test with my database you will see that it shows the first record in the database and not the first record based on the selected year.

It now works just as if I entered a hard-coded date. It also responds as I indicated before. The combobox shows the 1st record in my database. When I do a pull-down, it shows me only the years that I am looking for. Is there a way to get the initial combobox setting to show the 1st record of the...

This code is already in a query. My Rowsource points to the query name. I've shown the value of the field in a Msgbox in the "on current" vba code, so I know it contains the correct value. As I said before, this works if I use a hard-coded date.

Also, why does it work when I use a hard coded date? the only time it doensn't work is when I use a field variable.

TNameDateTime is a String field containing a Name concatenated with a Date concatenated with a Time. This is what I want to show in the combobox. Date is another field in my database that I'm trying to filter on. Is this not possible?