Recent content by ozsupra

Addit:- You will find that the ComboBox remembers the last entry when reopening (before running "OnLoad") so it is good practice to add the same code to the form "Close" process

There are multiple ways to skin a cat. I had the same problem and used a trick to fool the users. I set the font colour to that of the background so that the user thinks the record is blank. I then change the colour on the update.

Except there is a considerable amount of other functionality that wouldn't work that way. Any suggestions? A.

See Attached If I click on a list item on the subform I expect to see the items on the main form (arrows) change. Thanks.

Subform is a list view of all filtered products. Yes the Mainform shows the "first" products details, I would just like to then click on another entry in the list/subform and see the details for another product in the list and so on. A.

I have a table which contains products. A product can be "ordered" "delivered" or "dispatched". I have three queries that filter on those states. I have a main form that shows all the additional information associated with that product and three sub forms based on each of the queries. Buttons...

Then is must be build specific, because I have tried all the solutions mentioned without any success. I am however leaning towards it being an option group issue as a number of my forms were imported from Access 2003 and I was in the habit of deleting the label on an option group to make a...

Thanks that does work however I still don't understand why the general date format doesn't. Even txtYourTextBox.Format = "dd/mm/yyyy, hh:nn" doesn't capture the time :confused: :confused: :confused:

I have set a field on my FORM with the General Date format. Every time I use the date picker it inserts the correct date with a time of 00:00? I even changed the format on my table to general date - still no luck I don't understand why?

JHB - Excellent, that's just the ticket. Thanks so much!!!

Thanks Mark. Whilst a listbox may be an easier option (and it is) sometimes it just isn't the solution that works best for the end user. I really need some guidance on refreshing the main form after clicking on a particular subform record. Surely this can't be that difficult? ?

I have been unable to work this one out and I'm sure the answer is fairly simple. I have a subform (A) that shows all records in a table in a list format. The form (B) shows only the current record. I am attempting to click on a record on the subform list (A) and for that record to display on...

It's probably staring me right in the face - but I can't see it. Please find attached the little buggers. Thanks in advance.

It's doing a number of sorts and has a single filter that's all.

I have a query based on two other queries If I create a form based on the fields in my query the form will not allow me to edit any fields - no matter what. All fields are unique however I am stumped as to why I can't edit the data. Even adding in the second query immediately stops data entry...