Search results

Thanks X100

Exactly..thats what i mean.

Populating fields in a form Yes. You are right.

Populating fields in a form. Yes i have tried the combo box wizard. But what i need to achieve is to get the seperate records for a particular ID. Example, when I choose Staff ID 111, in a seperate text box I need the name to be displayed automatically, in an other seperate text box the...

I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.

Ell Done. It Worked fine Thanks

Thanks it worked

Imagine a form where you have to input time value, example 15:30 or 02:00 etc... Is there a simple way to input 1530 or 0200 and access converts the value into proper time? The reason is to eliminate using the ":" each time.

I am trying to build a form to calculate time elapsed/time difference. Example if one turns up for work at 1900hrs (start) and ends his duty at 0200hrs the next day (end), how much time has elapsed? I am trying to use this argument : Elapsed: IIf([end] > [start], Format([end] - [start], "Short...