Recent content by nq

Thanks PH. Problem solved.

The query for the sub-form would have to be based on tblPlacement and tblReports. This will only return results when there is an entry in both tables. Initially, a student may have a placement but no report. Therefore when displaying the student, if the sub-form was based on the query and not...

I have a db with 3 tables: tblStudent, tblPlacement and tbl Reports. There is a main form displaying each student record, within the main form is a sub-form displaying every placement the student has had. Within each placement record in the sub-form there is a button. When the button is clicked...

Remou Thank you, exactly what I was looking for.

I have a form based on a table. The table contains several fields that have "required" data. The controls on the form allow users to enter the data. The form also allows the user to change to another record. If the user enters some data and then moves to another record before filling in all...

BarneyOwl. No, the rectangle is used to surround several boxes - hence the problem. Thanks for the clue MichaelRed. I did search before asking - obviously the wrong key words. I used something similar to the code below. I had to change the layout so it's not an ideal solution but it works. I'll...

I have a report that prints a major topic heading followed by a group of data spread over several lines. There may be several groups of data pertaining to the major heading. To differentiate between individual groups, I have enclosed each group by a rectangle. One of the fields in the group of...

Thanks guys. Problem solved. I set the format on the properties of "Witdrawn" in the select query.

on a form, current event, perform a requery on the combo box: Private Sub Form_Current() Me!cboName.Requery End Sub or a generic: DoCmd.Requery

Perform a requery

This is a convoluted question. Please be patient for those who are willing to accept the challenge. I have two databases. The first is the primary db. The second db is required to be seperate for security reasons but accesses some tables in the primary db via linking. In the first db, there is...

Guys. Thanks for all the feedback. It has given me a lot to think about. I could not get the following (or similar) code to work on the default value: ="=" & chr(34) & [tblParameters]![campus] & chr(34) However, I will analyse it and see what I need to learn to make it work. The good news is...

Remou - didn't seem to work. I tried: ="=" & [tblParameters]![campus] since "campus" is text, I also tried: ="=" & [tblParameters]!["campus"] Aceman - The form is open displaying a record. Click a button to add a new record - all the fields go blank except those that have default values. The...

I have a combo box on a form which is bound to a table. The "row source type" is a value list and I have typed in the values for "row source". A "default value" is also set. I have a need to occasionally change the "default value". The new value can be selected from another table. ie not the...

G'Day. And thanks for showing me the "NotInList" event. I don't remember seeing it before but I can see uses for it to make user operation more satisying. Thanks again.