List Box ?

J

Jeff C

Is there anyway to have a "list box" type field on a data entry form that
allows you to enter the value you want (a date) and that keeps the old dates
in the list below the new entry?
 
S

Sprinks

Hi, Jeff.

A List Box has a precise meaning in Access--it is a form *control* whose
rows come from a query. Once a value is selected, that value is saved to the
list box' Control Source, which is a *field* in the form's underlying
RecordSource.

I can't tell from you're brief description, but it sounds as if you want to
enter a new record, which might be done from a continuous subform.

Please give a more complete generic description of what you're trying to do,
and someone will be able to assist you.

Sprinks
 
J

Jeff C

Ideally, I would like a data entry field on my form to open up just like a
list box does. The data type is short date with an input screen.....The list
would always open up to a black top line where a new date could be entered
and the rows below that would hold any dates entered previously. If directed
I can cut and paste code but I really do not know VB.
 
S

Sprinks

Hi, Jeff.

Sounds to me like a combo box with the Limit to List property set to No
would do it, all though it would certainly help to know:

The RowSource of the combo box
If you store the selected or entered value in an underlying field
The RecordSource of the form
etc.

Hope that solves it.
Sprinks
 
J

Jeff C

I think you are getting close, I am pretty new with this.....each record has
an autonumber primary key..should I create a new table to hold all the dates?
One record to many dates relationally? if so how? I appreciate your help
so far.
 
S

Sprinks

What do these dates represent? I'd actually assumed they were already IN a
table, otherwise, how would you be showing them in a list box? If they
really ARE detail records on the many side of a one-to-many relationship, the
detail records belong in a subform, related to the One side by a common
field. For example, if these records represented phone conversations with a
customer, I'd assume the table structures were something like:

Customers
------------------
CustomerID AutoNumber PK
CustName Text
Address Text
City
etc.

PhoneContacts
--------------------
PCID AutoNumber PK
CustomerID Number (Foreign Key to Customer)
ContactDate Date/Time
Note Text or Memo

A continuous form based on the PhoneContacts would be inserted onto a main
form based on Customers as a subform, linking by the CustomerID field. If
you do not have wizards enabled when you insert the subform, you will have to
set the LinkMasterField and LinkChildField subform properties manually. They
represent the linking field in the main form RecordSource and subform
RecordSource, respectively.

If this doesn't help, you're going to have to explain the structure of your
table(s) and what these dates represent, in as much detail as possible.

Sprinks
 
J

Jeff C

Each record has a field named [Current Test Date] and every record has an
entry in this field formatted short date with an input screen. I am
envisioning what appears to be a list box with this [Current Test Date]
showing, and when I open the box it drops down to list all the precious dates
under the crrent one.
 
Top