Hi everyone,
Some of you may have seen the problem already. To make the questions more clearly, I have attached the db file.
Basically, in this database, I have three tables.
Maintable includes several fields, such as ID (primary key), Name, Date, [Sent To 1], [Other Sent To], [Purpose], Topic1, OtherTopic.
I also have SentCopiedTo table including ID (primary key) and ReferName, and Topics Table including ID (primary key) and Topic.
The [Sent To 1] field in the MainTable refer to the SentCopiedTo table, and the Topic1 field refer to Topics Table.
I also have two forms - Entryform and SearchForm. EntryForm shows all the detail of the record in MainTable(one of the tables) and also can insert the new record. SearchForm shows the list of results matching the search criteria which containing Name, Date Range, and etc. The qry_search_Form query is the one to search the result for the searchForm.
My problems with this database are:
1. Entryform and SearchForm, which are independ to each other. An empty record has to be inserted when EntryForm is opened. When the results are listed in the SearchForm, I set that its open its corresponding record in the EntryForm when clicking one of the Id in the list. However, it shows an empty record instead of the record with the ID. I have to click <| at the bottom of the form, then it will go to the record having the ID. How to show only the record with the ID in OpenForm when clicking the ID in the searchForm?
2. The criteria in the SearchForm contains a combo box SentTo and a textbox beside it. SentTo Combo box is a list value from the SentCopiedTo. The query get the results that Maintable.[Sent To 1 ] matches the value of SentTo Combo box or Maintable.[OtherSentTo] matching the textbox. Is there any way to get the same results by using one textbox instead of one combo box and one textbox?
3. The criteria in the SearchForm also includes one combo box called Purpose, which is a value list such as "Draft Reply", "Response", and etc. Same as the Purpose data field in Maintable. However, the qry_searchform doesn't work when I use Maintable.Purpose like "*" & forms!search_form!Purpose & "*" at the where clause. The Topic1 combo box in the SearchForm doesn't work either. Since these two datafields in the Maintable are text, I have tried to change to Number. However, it gave me an error, which said that it will delete the records. Anyone knows how to solve it without changing the datatype for this two datafields in the MainTable?
Thanks a lot! Your help will be appreciated greatly.
Vicgirl
Some of you may have seen the problem already. To make the questions more clearly, I have attached the db file.
Basically, in this database, I have three tables.
Maintable includes several fields, such as ID (primary key), Name, Date, [Sent To 1], [Other Sent To], [Purpose], Topic1, OtherTopic.
I also have SentCopiedTo table including ID (primary key) and ReferName, and Topics Table including ID (primary key) and Topic.
The [Sent To 1] field in the MainTable refer to the SentCopiedTo table, and the Topic1 field refer to Topics Table.
I also have two forms - Entryform and SearchForm. EntryForm shows all the detail of the record in MainTable(one of the tables) and also can insert the new record. SearchForm shows the list of results matching the search criteria which containing Name, Date Range, and etc. The qry_search_Form query is the one to search the result for the searchForm.
My problems with this database are:
1. Entryform and SearchForm, which are independ to each other. An empty record has to be inserted when EntryForm is opened. When the results are listed in the SearchForm, I set that its open its corresponding record in the EntryForm when clicking one of the Id in the list. However, it shows an empty record instead of the record with the ID. I have to click <| at the bottom of the form, then it will go to the record having the ID. How to show only the record with the ID in OpenForm when clicking the ID in the searchForm?
2. The criteria in the SearchForm contains a combo box SentTo and a textbox beside it. SentTo Combo box is a list value from the SentCopiedTo. The query get the results that Maintable.[Sent To 1 ] matches the value of SentTo Combo box or Maintable.[OtherSentTo] matching the textbox. Is there any way to get the same results by using one textbox instead of one combo box and one textbox?
3. The criteria in the SearchForm also includes one combo box called Purpose, which is a value list such as "Draft Reply", "Response", and etc. Same as the Purpose data field in Maintable. However, the qry_searchform doesn't work when I use Maintable.Purpose like "*" & forms!search_form!Purpose & "*" at the where clause. The Topic1 combo box in the SearchForm doesn't work either. Since these two datafields in the Maintable are text, I have tried to change to Number. However, it gave me an error, which said that it will delete the records. Anyone knows how to solve it without changing the datatype for this two datafields in the MainTable?
Thanks a lot! Your help will be appreciated greatly.
Vicgirl
Last edited:
