I’m having an interesting problem with a form and hope I can adequately
explain it.
Here goes.
I have 5 objects

Hello, could anyone please help. I have unbound combo box as a serach box in
the main form. What I want to achive is when I type in a name for serach in
the combo box, I want the drop down list to appear, and a list of name will
appear according the serach string. for example. ...

I am working with a report, and trying to get it to display inform from a
query.  There query has a field for Area of Study with Any Other Curriculum
as an option.  There is then also an Other field, where the area of study can
be further expounded upon if it is not within the ...

I have an Access Database with a form on it that has 3 combo boxes 1 Flex
grid and 1 list box.  The combo boxes display specific data based on a user
selection in the flex grid or the list box.  the flex grid shows current
appointments and the list box shows cancelled ...

Is there a forumla to calculate the needed height of a listbox in order to
contain a given number of lines of a given point size?

I need to create a form in Access that will search few fields and based on
the condition will produce the search result in datasheet like result.
However, the result set need to be able to be updated. Is this possible? I
had created a search form some time back where the ...

What am I doing wrong with DLookup below?  I think the solution lies
in how to access a field in another main form from a main form.
I keep getting an error saying "You Canceled the Previous Operation".
The key:  DCount below--see the line after "'''''''''''''''''''''''

I have an unbound form in which I have (amongst others) two comboboxes with
mandatory data.
Although I present a combobox, limited to the choices to pick out, people
manage not to fill in those data and to jump via the TAB-key to the next

I have a form that has several fields to save data in for achieve
purposes. I also have a search form that pulls that data and displays it,
each in an individual line.  It would be ideal to be able to click on a
search result and then on the main form have that record be ...

why this code work correctly with out ((((((End If))))))
Private Sub Command1_Click()
Dim a
Dim b

I was wondering if anyone knows how to get one field to populate the same
datainto another field? In other words:
I have a date field "Funding Date" and when the user enters the funding
date, I want the txtDateFrom1 field to automatically populate with the same

In a textbox or combobox how do I get the "On Keypress" event to
detect a return. The code "If KeyAscii = vbKeyReturn" doesn't work (at
least for me.)
Thanks

I have a continuous form with lots of data on it.
In the form footer I would like to average certain fields by checking a
checkbox next to the fields (in the detail section) I would like included in
the average.

I am not new to Access but have not used modules, etc. very much. On a form
I have a script about 80 lines long that I want to run on the lost focus
event of 20 different text boxes. It checks all values against new
calculations. The code has been tested and runs fine.

I am using Access 2007 in 2002-2003 mode.
I have a memo field in a linked table tbl_tasks.description.  When I
use the Listbox wizard to create a listbox, at the point where the
wizard shows me what fields are available to include in the Listbox,