Insert value for the whole field

[hr833]

I hoping to make things easier for my cilents. Below i have the fields for a table

Table one
Month
Customer
Transaction Amt

I wish to prompt the user for the month in which the records belong to.
Eg. In the Month of September i enter 100 records.

The Month field will automatically fill with "September" so that the user need not type september for a 100 times.

Should i use a INSERT sql? how should i go abt doing it?

Please and Thank you ppl!

[Scott Price]

I hoping to make things easier for my cilents. Below i have the fields for a table

Table one
Month
Customer
Transaction Amt

I wish to prompt the user for the month in which the records belong to.
Eg. In the Month of September i enter 100 records.

The Month field will automatically fill with "September" so that the user need not type september for a 100 times.

Should i use a INSERT sql? how should i go abt doing it?

Please and Thank you ppl!

Try setting the default value of the Month field in your table to this:

=Format(Date(),"mmmm")

Any new records will automatically have the current month of the current year entered.

Regards,
Scott

[hr833]

Try setting the default value of the Month field in your table to this:

=Format(Date(),"mmmm")

Any new records will automatically have the current month of the current year entered.

Regards,
Scott

Hey Scott,

The format works perfectly fine. However, the thing is the records are normally entered at the end of the month, some times even entered in the start of following month.Thus i require to prompt the cilent for the month of record belongs to.

Please and Thank you if you can help me..

[Scott Price]

Oh for *reeeeasonable* clients that do things the *right* way and enter their records on time... :-)

I would suggest then that you populate the Month field by using a combo box with RowSource of either a lookup table (tblMonth, MonthID, MonthName), or a value list that is set to the 12 months of the year. Make the Month field mandatory at the table level, and you're set, since there is no way that they can then save the record without entering a month value. (and BTW, since Month is a keyword, you should likely rename your field to something else to avoid confusing the poor computer down the road somewhere... MonthName, PayMonth, StatementMonth, etc)

Regards,
Scott