It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.
Cheers!

I have a field name called "Transaction No" in a table called BiddingData.
Yes, I put it in with a space between the words.
I'd like to get the field to automatically increase (similar to auto
number), but I run into problems because the field has a space in it.  My

My form has a subform (Link Child & Master field = ICNNO).
On that subform are two fields "CA_Name" and "CA_Decision" and they are both
Combo Boxes.
A different list is displayed in "CA_Decision" based on the choice made in

I have tried umpteen different ways to do this, but cannot get my head around
the complex syntax...
I double-click on a form control and want to go to a 2nd Subform elsewhere
on the Mainform.

I once had a code that would automatically scroll a continuous subform
to the last record as to show you that last "page" worth of records.
I'm trying to do something similar with a command button, where when
pressed, will move the continuous subform records forward or backward

I have a many to many setup with Contacts and Projects using an intermediate
table.  On my project data form, I have a subform for all associated
contacts.  This works.  When I double click the contacts I have an 'add
contact' form come up.  How do I associate that new entry with ...

I tried to create a switchboard, and it sorta operates
fine.  Except that when I open a form from the
switchboard, it can't access any records.  
I believe the form itself works in that I can add

I am working on a form "A" and i have created a Message box that has
'yes' and 'No' options.
if i click on the  yes button then it should open up a new form "B (in
this case FormAdd)"

I,m using two bound text fields to create a thrid unbound field they are:
2 bound to same table - [contractnum] and [fmscase] - both are text, format
= >, required = no, allow zero lenght = no, indexed = yes (dups ok).
The 3rd unbound field is [contract or fms no.] in it's control ...

A peculiar situation I have recently encountered involves a form and query
and when it is called from a form event, the query SQL is erased after the
query is run.  I will present the scenario below using FormA as an example.
On FormA I have four controls, a Preview Button, Export ...

I have a continuous form that I want to set field formatting on multiple
controls using VBA. I do not want to use the Conditional formatting.
Assuming I write my formatting code into a procedure, which event is the
appropriate place to invoke the code from?

there maybe is a bug involving tab in Access07 forms....
I looked to change the tab order of a form and the tab mgmt window isn't
showing all existing controls currently on the form....in this case in the
Detail section....

I am using:
CurrentDb.Execute "UPDATE tbl_Projects SET DateUpdated = Now()"
as suggested here, but it is updating ALL records, how do I specify the
record that was actully changed?

I'm using the following line in the form_open to select the first item in the
list which susequently selects data in the second listbox:
Me.lstDate.Selected(0) = True
However the whole form freezes and nothing works? Any ideas?

'add one textbox to form with Control Source = ID)
'here is simple form code:
'error 3450 - I can't find much info on this...
Private Sub Form_Load()