Access Form with Combo box

[Sevi]

Hi,

I was designing a form using access 2003. The form is based on a database
with 3 tables
In the form 6 fields are from Table 1 and 1 field each from Table2 and
Table3 respectively (both these are combo box). While running the form
system is not allowing me to select values in combo box.

can any one help me to save the record (including combo box linked to table
2 and table 3) to the Table 1.

Smiles Sevi

 

[Jeanette Cunningham]

Hi Sevi,
how the table relationships are set up is important for getting your form to
work.
Would you post back with the name of the tables, their primary keys, their
foreign keys (for tables 2 and 3) and the relationships between the tables.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Sevi]

Hi Jeanette,

Thanks a lot for your reply,

I was not aware of relationship and primary keys.

The structure of the tables are as follows:

Table 1

Serial Number Text
Date of Receipt Date/Time
Sent By Text To be captured from the combo in the form
Subject of the Mail Text
Assigned to Text
Replied on Date/Time
Replied by Text
Status Text To be captured from the combo in the form
Comments Text

Table 2

Satus Text linked to combo box

Table 3

Sent By Text Text linked to combo box

Can you please help me to solve this...

Smiles Sevi

 

[Jeanette Cunningham]

Here's how you can do it.
First, here is a suggestion for your main table.
Access doesn't like spaces in table names.
I renamed Table 1 as tblMail.

Access doesn't like spaces in field names
If you have a field called Serial Number Text, it will be easier to write
code if you change it to SerialNumberText - see how the spaces have been
removed.
Do the same for all the fields in the table.

Rename Table 1 as tblMail

Create a form based on tblMail.

Delete the textbox for Status.
Use the combo wizard like this:
On the forms Property List these is a list of the fields.
Highlight the field called Status.
Click the combo tool on the toolbox.
Now click on the form where you want the combo.
Follow the steps to create the combo.


Repeat the above process for SentByText.

Test the form. You should find that the data is saved in the table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Sevi]

Hi Jean,

I tried the solution you suggested...but bad luck it giving the same error
again
"control canot be edited, its bound to the expression 'tbl3![Sentby]' ""

Could you please generate a form as i mentioned......will be a great help.

smiles Sevi

 

[Sevi]

Hi Jean........tried the solution you suggested...

amazing...awsome....

I really learned something new......

Thanks a lot