Displaying info in an unbound text box and locking for editing

B

Bellyjeans

Hi everybody,

I have an unbound text box called "txtStartDateReadOnly" on a form
called "frmContactInfo". I would like txtStartDateReadOnly to display
data from a bound text box on another form, but have it greyed out and
locked for editing. This other form is called "frmAppointments" and
the text box in question is called "txtStartDate".

txtStartDate is normally invisible, but becomes invisible when a "yes"
value is selected in a combo box called "cboAppointment".

The underlying tables between frmContactInfo (tblStaffMain) and
frmAppointments (tblAppointments) have a one-to-many relationship: one
record in tblStaffMain can have many records in tblAppointments. I
want the unbound combo box (txtStartDateReadOnly) to pull only the
most recent appointment.

I hope that all makes sense. :) Any help would be much appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
unbound text box 1
Filter subform from combo unbound text box 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Autopopulate text box based on an unbound combo box 4
Unable to display values in 2nd list box from 1st list box selection 2
Auto Update Text box 1

Top