Help with Forms

[Richi]

First Sorry for my bad Englis
I new here and learning Access my question is
I have 2 Tables and 2 Form for this tables ,one is Main Table and have some info and the second have names exact 4 names every name is a record
Hove to move this records( 4 Names) in a single record thats in this 1 table ( main Table ) and when I start The form ( second ) form is Blank for new data that will send to the main table


It database for Travel Agency that make Travel Contracts

Thanks for your Help

[June7]

If you want the form to always open to a new record and not be able to view existing records, set the form DataEntry property to Yes.

Do not understand what you mean by 'move' records.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Richi]

Thanks

In 1 form ( table) I have some Data ( main Form ) and in the second form ( table ) I have Names ( klijents) all this togheder is a record
When I start a new record all is blank and old Data (table 1 and 2 ) are stored in a form number 3 in a list box for making contracts

[June7]

You have 3 forms, not 2?

Still don't understand. What data is in table 1?

[Richi]

data in table1 are for exp. data about travel; table 2 are passanger names which i write directly inside, table 1+table 2 = table 3 as one document in list box
Every time when I start form 1 it goes new entry for a new travel with new clients and at te end we do a contract for them
Tnk for your help

[June7]

Not sure what you are asking for.

If form 1 is to enter exp. records for a passenger, then I guess you need a combobox on form 1 to select passenger name and save their ID into exp. record.

How does table 1 + table 2 = table 3? How is this relevant to a listbox?

Going in circles here. Probably best I see what you have done. Provide database.

[Richi]

Her are only 2 Form
The database is in Croatian maybee you noth understand Croatian
I have make example This two tables in one that I can select it in a another form in a single file
In The listbox are the records from the second form ( table)
From this record create Contracts , Vouchers etc.

Thanks for Help

[June7]

That is an accde file. I cannot even open it. My Access doesn't recognize the file. I need the accdb version.

[Richi]

Here we go Try this

And Thanks for Help

[June7]

Why don't objects have meaningful names, like tblReservations and tblCustomers?

Table 1 has a field called Name (Name is a reserved word, should not use reserved words as field names). Change to something like CustName.

Is this supposed to be for a name selected from table 2? If so, then this should be a number field and save the ID number from table2. Instead of the Name textbox use a combobox. Review http://www.datapigtechnologies.com/f...combobox3.html
Combobox properties:
RowSource: SELECT ID, LastName & ", " & FirstName AS CustName FROM Table2
BoundColumn: 1
ControlSource: Name
ColumnCount: 2
ColumnWidths: 0";2.0:



Review tutorials about relational database http://www.rogersaccesslibrary.com/

[Richi]

No
Name is a Person (Costumer) thats have Book the Travel and this names in the second Table are klijent thats go with him in Hotel ( Wife ,Chlidern) all this Peapol must be on Contract and we must save this for latter that we can make invoice ,Travel Contract, Vouchers

is this Posible

[June7]

Certainly. Did you review the tutorials?

[Richi]

Yes
When I create Relation with tables Have erorr need related records from table 1 tblReservations and tblCustomers is ok
how to put it together in single record
The numbercontract is 1 record single from this 2 tables ,number 2 ,3 ect.

Thanks

[June7]

Sorry, cannot understand that. Too much language barrier. The translation fails.

The advice and examples already given should be enough to get a simple data entry form set up. This is very basic Access functionality.

[Richi]

Thanks

give up
closse therd

Thanks