I write the following in the Control Source property of a form text box, but
get a message that the syntax is wrong:
=DateDiff("d", date, [SidsteOfStatusændringDato])
What am I doing wrong?

Hello all...
I have a edit record form, which was working, until I added record
navigation buttons to the form (memberinfo) that has the edit record button
that opens it.

I have a main form bound to tblVendors with a subform bound to tblContacts.  
How can the user select one record from the subform, bring it to the main
form, and have it remain there every time the record on tblVendors is opened
until the user changes the subform record selection?

I have a form that I use to search records. There are two fields,
SearchSurname and SearchCallSign, and I only want to search based on one of
these.
Two things, I have created an AfterUpdate event that deletes(?) the other

I want the user to be able to re-order the records on a subform (ideally)
with a click, or very few key-strokes.
I have a number field called priority on a subform bound to
tblVendorContacts.  I want an easy way for the user to change the priority on

All, can you please help me in creating a form for search and make it
search-as-you-type way?
thanks.

How to I update a description text field on a form with the description from
another table based on an Item Number selected from a combo list?  The two
tables are joined on the Item Number.  I tried to an update query in the
after-update event on the combo box but it does not ...

I have a table with a required field set to yes. How do I capture the system
generated responce when the user fails to enter data in that field?
TIA
johnb

I have a form with several combo boxes which are "limit to list".  I have
another combo box that is disabled if the value in another field doesn't meet
certain criteria.  When the user clicks "filter by form", they can't enter
any wildcard strings into the "limit to list" combo ...

I can send a value as a criteria to a specific query if it is a text of a
textbox, combobax, label etc.
But, i wonder if i can send a variable to a guery...
I mean, such as...

I have a report which numbers the detail records using a text box, control =1
and running sum over all.  The report is generated by a form on which the
user numbers the items to control the order in which they appear in a number
field called [order]. If the item [order]= 0 , I ...

I've got a listbox on a form that is being populated after the form is
opened, based on user input to other fields.  If they enter different
information, I want to repopulate that listbox based on the new
information, but things start acting a little strange after I do

Hello all, I have a little question
I have some public constructs in a module, that I want to manipulate via a
form, mainly to keep users out of my VBA.  When I open the form, I have:
Private Sub Form_Open(Cancel As Integer)

Is there a way to populate a combo box with the tables names in the database?

I’m at a total loss!  I have two sets of eight controls, one large and one
small, that are paired up.  Either the large or small control of each pair
will be visible at any given time.  
Here is a sample of the code I use to switch the focus and the visibility: