I have a mainform on which is a subform. I use the .sourceobject property to
change the sourceobject of the subform to display various forms within the
subfoirm container...
If I hard code the form name as shown below the statement works no problem.

Hello, I'm setting some field in the unload event of the access 97 form.  
This works fine when running it but if I ever go into Design Mode it gives me
an error and I need to restart.  It gives me an error
Run-Time error '2448'.  You can't assign a value to this object.

In a form i would like the user to choose the id from a combo box, see the
name in a field and change the other fields. But when i select an ID from
combobox i dont see the record of this combobox in the form. I mean tha if i
have these record ID:1 Name:OP 1st:0 2nd:13rd:2 4rth:0 ...

Probably a silly question...
I have a popup form being called from a switchboard item.  How can I get the
code on the popup form to completely execute before the code on the
switchboard form continues.  For example, I want the code sequence to be as

I tried various ways but none of them seems to be accepted and bring any
result
I need something that expresses the year part of the current year as a param
in a query

When I try to click any button to open any form or try to open the module,
it always give me the following error and then close the mdb:
"Microsoft Access has encountered a problem and needs to close. We are sorry
for the inconvenience."

Hi I have been trying to use something like the following
code to validate a textboxes entry to ensure that the
contents are all of numbers and no more than six
characters long.  Please could somone tell me how to do

In code within access db I want to write the physical location of the
current db to a log file.
How do I go about getting the full path to the currently open access db?
That would be from within the database in question.

I posted the following message in the Macro section of
this forum and haven't received a response.  Hopefully,
this is the correct place to post a message of this type.
__________________________________________________________

I am a fairly new at access.  In General I thought I was making progress.  I
was close to releasing this application and was making some final changes.
It
seems that things that worked before dont work anymore.  Example: form a

I am using the code supplied by the combo box wizard to go to a specific
record based on the selection in the combo box. Code is as follows:
   ' Find the record that matches the control.
   Dim rs As Object

If a form is cancelled or closed without all boxes complete the data is not
written to the table. Can I design a warning message box saying "Data not
updated" in these circumstances?

Sorry to be a pest again, but I need to be able to find which tab is 'active'
on a Tab control on a form. The control has 4 tabs, called Tab1, Tab 2 etc.
I want to set a label field on the main form to a differet text depending on
which tab of the Tab control is active. Tha latter ...

In the form properties, I dont see anything that will disallow a user from
double clicking on the form header bar and maximizing it.  How do I prevent
this.  I searched the group posting, but returned no similar questions.  Help
is greatly appreciated.

I've been using myListBox.rowsource = mySQL and this works well.  Now I'd
like to assign a recordset to the listbox instead.
I've tried "myListBox.recordset = myRS " and " Set myListBoxSet.recordset =
myRS".  The first version gives a runtime error and the second version does