I have 2 questions.

In form i have combo box with two days in week. Let say Monday and Tuesday.
I would like second combo (or textbox) to update automatically on after update - if Monday =Wednesday, and if Tuesday = Thursday.


And second question is similar but with time.
If user enter time in first textbox 13:30 to update second one with 15:00 (to add 1h and 30 min).


Thanks you.

Hi,

Can you please post the Row Sources for your comboboxes? Thanks.

Just my 2 cents...

There is no row sources. Its value list. Its just word Monday writen in table.

So, even the time choices are also just a value list? What is the data type of the field in the table that stores the time value?

First one are comboboxes with value and text in table. I do it because usually (for now all) classes go mon-wed and tue-thu, but want to leave posibility for change that.
In tables there is field day1 and day2.

Time choices are txtbox and in tables i from and two field and i used date/time -> short date.


If that is wrong, please feel free to recommend better way.

Hmm... Having fields like "day1" and "day2" sounds a bit suspiciously like a bad design at this point. If you can describe what your database is used for, we might be able to give you some ideas on the appropriate table structure.

Just my 2 cents...

School. They are group that go at mon-wed or tue-thu and they can be are few in that days.

So i have ID, ID of Modul (English language A1-1) Profesor ID and what day and tme are they.

That two represent only information so when student come and sign a contract they chose what group they will go based on when student can go.

Hi,

It is very important to get the table structure for your data before worrying about how the user will interact with them. Once you get the data in the proper format, designing the user interface would become easier.

Can you post your table structure?

Just my 2 cents...